You can get the column number into a formula using the Column() function.
However, your requirement seems to be more complex than that The Match() function will look up a value in a range of cells and return the number of the find in the range. If your range starts at column A and is only in one row, then this would equate to the column number.
Regards, Dave S
----- Original Message -----Sent: Wednesday, July 13, 2016 1:12 AMSubject: [ExcelVBA] Formula to return column numberMorning everyone,
I need your advice. Is there a way to have a column number returned through a formula?
For example: I have sheet1 and sheet2. Sheet1 have data represented vertically with Cell A1, B1, C1 so on have the names like Tranche, Category, Pricing, and so on..
Sheet2 have names Tranche, Category, Pricing in cell A1, A2 & A3. I want cell B1, B2 & B3 to show the column number where aforementioned names are appearing in Sheet1.
Thanks in advance for your help!
Thank you,
Taurean
__._,_.___
Posted by: "David Smart" <smartware.consulting@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar