kaseyleigh
New Member
- Joined
- Oct 11, 2006
- Messages
- 9
I have ranges of criteria (27 of them!) I need to replace with another name, I could use the IF function but this only allows 7 nested statements, therefore, needing to use 4 cells all linking to the previous in order to do this. This also makes it a headache when trying to adjust the ranges!!
Anyone got brilliant ideas how to solve my problem?!
I was hoping for a nice laid out table that I could type into and it linked somehow .... Ihave reached a dead end.
Please help.
Ta
Kasey
Anyone got brilliant ideas how to solve my problem?!
I was hoping for a nice laid out table that I could type into and it linked somehow .... Ihave reached a dead end.
Please help.
Ta
Kasey