|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 19th, 2009, 09:55 PM
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
July 20th, 2009, 02:39 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
