| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 columns
How can I make my formula look in two columns as if it were one without messing up the formula ? simply holding control to select the second column data doesn't seem to be working is there a way to name the two columns in advance or something then call it in the formula? -- darkbearpooh1 ------------------------------------------------------------------------ darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640 View this thread: http://www.excelforum.com/showthread...hreadid=514891 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 columns
What formula do you have (or are thinking of creating)? Are your two
columns adjacent? Pete |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 columns
=IF(ISNA(MATCH($A7,INDIRECT(B$5&"!H28:H46"),0)),"" ,SUMIF(INDIRECT(B$5&"!H28:H46"),$A7,INDIRECT(B$5&" !I28:I46"))) this formula to lookup from another sheet but the H28:H46 needs to also be combined to look in BC28:BC46 and find the answer in not only I28:I46 but also AY28:AY46 -- darkbearpooh1 ------------------------------------------------------------------------ darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640 View this thread: http://www.excelforum.com/showthread...hreadid=514891 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 columns
See your other thread.
Biff "darkbearpooh1" wrote in message news:darkbearpooh1.23l3cy_1140533106.633@excelforu m-nospam.com... How can I make my formula look in two columns as if it were one without messing up the formula ? simply holding control to select the second column data doesn't seem to be working is there a way to name the two columns in advance or something then call it in the formula? -- darkbearpooh1 ------------------------------------------------------------------------ darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640 View this thread: http://www.excelforum.com/showthread...hreadid=514891 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Linear Mode
