| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change data on number change
I have a table that has data in it. I would like to be able to change the
Column number and the Row Number to change what displays in A4. Is there an easy way to do this? If I would type in Column 4 row 10 I would get Test7 in A4 Thanks! Jeff A B C D 1 Column 1 2 Row 8 3 4 Test 1 5 6 7 8 Test 2 Test5 9 Test3 Test6 10 Test4 Test7 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change data on number change
One way
Put in A4: =IF(COUNT(B1:B2)<2,"",OFFSET($A$1,B2-1,B1-1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jeff" wrote: I have a table that has data in it. I would like to be able to change the Column number and the Row Number to change what displays in A4. Is there an easy way to do this? If I would type in Column 4 row 10 I would get Test7 in A4 Thanks! Jeff A B C D 1 Column 1 2 Row 8 3 4 Test 1 5 6 7 8 Test 2 Test5 9 Test3 Test6 10 Test4 Test7 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change data on number change
Put in A4: =IF(COUNT(B1:B2)<2,"",OFFSET($A$1,B2-1,B1-1))
Inputs assumed in B1: Column#, in B2: Row# (as you indicated in your posting) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change data on number change
That works very well. Thank you! Also if I would like to put the data on a
separate sheet how can I do that? "Max" wrote: One way Put in A4: =IF(COUNT(B1:B2)<2,"",OFFSET($A$1,B2-1,B1-1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jeff" wrote: I have a table that has data in it. I would like to be able to change the Column number and the Row Number to change what displays in A4. Is there an easy way to do this? If I would type in Column 4 row 10 I would get Test7 in A4 Thanks! Jeff A B C D 1 Column 1 2 Row 8 3 4 Test 1 5 6 7 8 Test 2 Test5 9 Test3 Test6 10 Test4 Test7 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change data on number change
"Jeff" wrote:
That works very well. Thank you! Welcome. Pl click the "Yes" button below. Also if I would like to put the data on a separate sheet how can I do that? No problem, if the data is in Sheet2 .. In Sheet1, with the col/row inputs in B1:B2 as before, you just use: =IF(COUNT(B1:B2)<2,"",OFFSET(Sheet2!$A$1,B2-1,B1-1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change data on number change
That is what I needed. Thanks! You are a lot of help. I also went to your web
site. Nice! "Max" wrote: "Jeff" wrote: That works very well. Thank you! Welcome. Pl click the "Yes" button below. Also if I would like to put the data on a separate sheet how can I do that? No problem, if the data is in Sheet2 .. In Sheet1, with the col/row inputs in B1:B2 as before, you just use: =IF(COUNT(B1:B2)<2,"",OFFSET(Sheet2!$A$1,B2-1,B1-1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change data on number change
welcome, Jeff.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jeff" wrote in message ... That is what I needed. Thanks! You are a lot of help. I also went to your web site. Nice! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Change results , change data in othe cells across the row | Excel Worksheet Functions | |||
| How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| compare 2 data bases that change each month. Only account number | New Users to Excel | |||
Linear Mode
