Forum Discussion
extract info from an excel table to separate worksheet
Hello I have a very long table with lots of columns and at the end is the info I want to use to form a dashboard (I've copied a very small sample below) I want to extract (?) from this worksheet a ...
Thanks for this - unfortunately as I've got an older version of Excel the Filter function isn't available.
I'll try your solution when we upgrade our systems, soon hopefully!
Thanks !
April
I'll try your solution when we upgrade our systems, soon hopefully!
Thanks !
April
Here is a formula that works in all versions of Excel. See attachment.