Printable View
@ Admin,
Yes I know ISERROR was released with 2007 (I didn't post that solution BTW).
Like the solution posted by aju.thomas, your solution again only works till 8-Jan and has an extra space between "a" and "l" in "General" (must be a formatting issue with the web page).
Robert
Yes, it is working only until January 8, but do not come with the rest of the values
Perhaps if you post a file with one (or both) of the macros attached we can see why it's not working and advise accordingly.
This is the file that you want to work examples
With a formula Mister Admin
The file didn't have either macro attached :confused:
Anyway, run the ExcelFox macro from the Macro dialog (opened via pressing and holding the Alt button followed by pressing the F8 key) on the data in Sheet2 to get the desired results.
HTH
Robert