Hi eoghanmolloy,
Try using below formula;-
Formula:Please Login or Register to view this content.
test.zip
Enter formula using ctrl shift enter key combination.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi DILIPandey,
I must be doing something stupid here. I've inserted your formula into Test1.xls and pressed Ctrl, Shift and Enter but nothing seems to be happening...
It might be something to do with me using Excel 2003??
may be .. if error function will not work in 2003, try below one :-
Formula:Please Login or Register to view this content.
confirm with Ctrl shift enter
Regards,
DILIPandey
<click on below 'star' if this helps>
Each cell is now apearing with '################'??
okay.. upload your sample workbook.. thanks.
I hope you are using correct references as per formula requirement as in my workbook
Regards,
DILIPandey
<click on below 'star' if this helps>
Here is Test1.xls
Hi DILIPandey,
Have you had a chance to look at my problem?
yes... your formula cells are formatted as Text. Change the format to General and try again. thanks.
for more information, see the zip file which uploaded earlier.. and try matching the cell format.. in case of any issues, upload your BOTH workbooks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Thank you...working perfectly now!
you are welcome eoghanmolloy..
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks