Hi all,
I want to create an algorithm that gives the column number of the first, second, third etc. non-zero value of a row of data.
These column numbers should then be displayed in a horizontal fashion.
Can anybody please help?
Cheers!
Hi all,
I want to create an algorithm that gives the column number of the first, second, third etc. non-zero value of a row of data.
These column numbers should then be displayed in a horizontal fashion.
Can anybody please help?
Cheers!
Do you have a sample file with an expected output tab that you could upload? It will help us to understand your requirement better.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Here is the sample file. I created a little example of how the output should look like.
Cheers and thanks already!
an array formula
Please Login or Register to view this content.
Thank you so much!!!!!
It works perfect!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks