Hi,
I created dynamic consolidated list using formulas listed in title.
When lists contain numbers everything is fine, but when I put text #VALUE! error occur only in 3rd list.
Hope I wrote clearly. If not everything is nice shown in attached excel file.
change name of TAB SI to i.e. SX, and try this in A1 and copy down
Logical_test Required
Please Login or Register to view this content.
Last edited by sandy666; 03-03-2015 at 09:07 PM. Reason: changed SI to SX
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks