| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Comparing columns, need to quickly change what cols being compared
Comparing 2017 rate to 2018
Trying to make process quick and simple 3 sheets 2017 2018 Compare Yearly sheets are identical in format, one column per customer, various services listed down col A, only difference is the rates for each year. In COMPARE tab, Col B maps to 2017 customer, col C to same customer in col C. I currently change cell B1 and C1 to match customer column I need and just copy down. I want to make it a bit more sexy. Enter in a cell the column from 2017 that I want and a cell that ref col in 2018. Or enter a customer name for each year and it populates each column. TIA Jerry |
|
#2
|
|||
|
|||
|
indirect
Resolved
Used indirect function, which I had never knew about |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a value when two columns are compared | Excel Worksheet Functions | |||
| Enhance sub to copy cols of variable length into 1 col to snake results into other cols | Excel Programming | |||
| comparing two cols and placing blanks. | Excel Discussion (Misc queries) | |||
| Range.Select 1st pass 13 cols, 2nd paqss 25 cols twice as wide in error? | Excel Programming | |||
| comparing many cols of data to one col | Excel Worksheet Functions | |||
Linear Mode
