#1
|
|||
|
|||
Using the columns functions
hello guys, i have a question in a test that sounds like this,
Using the Columns function get the Row number in wich values: "11:00 AM"; "Number2" and "Name2" reside in Question Table. The result should be a formula that will work when you drag it to the right how can i use the columns function to get a row number? thanks for your time |
#2
|
|||
|
|||
In it's simplest form, put this in A1 and drag to the right.
=COLUMN(A1) This will convert column A and so on to a number. Even though your spreadsheet has letters running horizontally and numbers vertically, the spreadsheet is actually a grid. To illustrate this on your spreadsheet... File >> Options >> Excel Options >> Formulas >> Working with formulas>> R1C1 reference style |
#3
|
|||
|
|||
Hey, thanks for the quick response, but in my case the 11:00 AM case, is in B42, and the test tell me to use the columns formula in combination with another formula of course, to find out the row number which in my case is 42.
Just using Column() will give me the number 2.. |
#4
|
|||
|
|||
What column is equal to 42? I've already explained how you can determine which column is 42. Since this is a test, I don't want to do it for you.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Split selected columns, or all columns exept for Column1 | Cendrinne | Word VBA | 2 | 09-20-2019 09:14 PM |
Appear Diasppear - functions | EPN | PowerPoint | 3 | 03-17-2018 10:52 AM |
excel functions | Dotty | Excel | 1 | 05-11-2015 03:38 PM |
** Using Functions | djreyrey | Excel Programming | 10 | 02-08-2011 04:18 PM |
How to compare 2 columns with other two columns in EXECL 2007? | Learner7 | Excel | 5 | 06-12-2010 09:54 AM |