Hello people,
My name Vincent and I need help with designing a formula to arrange one set of numbers numbers in the correct column.
I've been at in the whole day and it's going nowhere.
I'm well familiar with excel and its formulas, but not very good at it.
Se attachement for details. I hope it it explains what I mean.
//Vincent
Here's one way; In 21A put this formulaand drag down and across.
=IF(ISERROR(MATCH(COLUMN(),2:2,0)),"",COLUMN())
This looks in Row 2 for a match to the column # (which is 1 for this cell). If it finds a match in that row, it puts it in. If it doesn't find it (an error is returned), then it leaves the cell blank. Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks