In excelI want to compare three columns in one row (day, month and yr) with the three cells below and if the same (i.e. the same day, mth and yr) compare the values in the fourth column for the same two rows and return the greatest value in that fourth column?
this is an example that ok? I want to put in the last column the highest FDI for a day
Thanks its great if there are always two values for one day but sometimes there are more or less than that i.e. sometimes there will be more rows (FDIs) for the same date or only one entry - I want to end up with a list of dates and the highest FDI value for that date?
Yep sorry, no. of rows varies - sometimes several or many records for one day i think not more than 48 (one every half hr), sometimes only two.
So i'm trying to extract from the data set the highest FDI for each day
thank you Jason.
Hi yes a new column fine, but I have a lot of data (over 20yrs) with days, months and year?
Hello Jess the data is on one excel worksheet all in separate columns as above.
could send workbook with the one worksheet and four columns of data if that helps.
wikisend not working for me can i email it direct somehow, its only few Kbs
Ok here it is file id 575762
http://wikisend.com/download/575762/Benalls Shadford St data.xlsx
Thanks Jess looks great, excellent work and rated accordingly :)