Forum

@riny Thanks Riny, that has worked.

@alansidman Hi Alan, I need to see if any of the numbers in column A appear in columns B to F Thanks, Paul

Thanks Riny

Thanks Riny, I thought that was the case, just wanted confirmation

Thank you Saliha.

Thanks Riny

Hi Velouria, I have attached an updated the attached sheet, When I add in all other services the old formula (cell C185) returns an average of a...

Thanks Velouria, I'm away at the moment, let me try this when I get back, will confirm all OK the, Regards Paul

Thanks Riny & Velouria @Velouria: the formula works but gives me the average of all 2382 rows, I need to know the average for each of the ...

Thanks for your help, all sorted now. Regards Paul