Search results

Hi, I get the following error with the formula, are you able to assist, thanks "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated

thank you so much, I will replace the red character with a number and change formula to suit. The data is too large in workbook to change columns. Will try when next at work

https://www.dropbox.com/s/1lmia11u5bawlli/test.xlsx thanks SirJB7

Hi Smallman, unfortunately I would have to add 4 columns for every one in the sheet and redo the data. If I am not able to count I will change the sheet. thanks

Hope someone is able to assist, would like to count data that meets three criteria in a large range. If it is between a date range AND text equals a name AND any part of the cell has red text. eg, column A between 1 Jul 13 to 31 Jul 13 AND Column B text equals Smith AND Column C any part of...

Thanks Sajan, Narayan an Faseeh, I cleaned up the workbook and removed unneccessary formulas and all is working really well. Appreciate the quick responses, I will certainly learn alot from this site.

thanks Sajan, works well only probelm is I am using the formula nested in a multiple IF statement, calculating the large workbook is really slow - any suggestions

Hi Narayan an Faseeh, If the 'EOM Date' TAB 2 cell value <= 'EOM Date' TAB 1 date AND 'Ref' cell value TAB 2 = 'Ref' TAB 2, return the value from 'Col 2' TAB 1 for the last data that is equal to or less than the date in EOM date TAB 1 EOM Date REF COL 1 COL 2...

Hi all, I just joined and browsing the forum Narayan, what formula would you use if the dates were not sorted in any order and you wanted last instance of a date that was used several times? Thanks, Leeann