Hi there!
I have an excel file with several tabs. In a new tab I want to list all values of Columns A of the various tabs, when Column F of the corresponding row is not blank.
Can anyone explain me which formula to use?
Many thanks!!
Hi there!
I have an excel file with several tabs. In a new tab I want to list all values of Columns A of the various tabs, when Column F of the corresponding row is not blank.
Can anyone explain me which formula to use?
Many thanks!!
You could do this by having a helper column in each of your existing tabs which identifies records which meet the criteria and allocates a unique number to them.
In the new tab you can then list all the matching records from all the other tabs, by means of a small lookup table.
Consequently, there isn't just one formula to use. As you are in Holland, the formulae will also have to be converted into Dutch, making use of your Regional settings.
It would help if you attached a sample Excel workbook, so that I can set this up for you and post it back.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Please note that the Paperclip icon (Attachments button) does not work.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks