| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to read value of a cell in a relative location
I use data filters to display products from a particular vendor. When I apply
a filter, I want cell A1 to display the value of the cell that appears one row down and one column to the left of the cell A1. Thank you! -- Anatoly |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to read value of a cell in a relative location
one column to the left of the cell A1.
There is no column to the left of column A. Need more detail. Tell us where the filter drop downs are located. -- Biff Microsoft Excel MVP "AnatolyV" wrote in message ... I use data filters to display products from a particular vendor. When I apply a filter, I want cell A1 to display the value of the cell that appears one row down and one column to the left of the cell A1. Thank you! -- Anatoly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| Open From Read-Only Location ? | Excel Discussion (Misc queries) | |||
| Displaying a cell relative to the position to another cell | Excel Discussion (Misc queries) | |||
| automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
| How do I sum using relative cell positions? | Excel Worksheet Functions | |||
Hybrid Mode
