I have cells that all reference from a 4x147 table, each row has one piece of data in, but only one piece from a choice of 4 cells (3 of which are blank).
the cells that are referencing this data, i would like to make them reference to all 4 cells, ignore the blanks and choose the one with the data.
how can i do this?
thanks
Last edited by will.girling; 11-22-2013 at 12:51 PM.
would need a bit more info on what is the data and what you are using the references for really, an example would be good.
If you want text then:
=concatenate(A1:A4)
would probably work.
Edit:
=1*concatenate(A1:A4) might work for numbers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks