| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pick the first value in a filtered range - vb code pls
hi
Whenever i change the filter a new set of data is shown. I want the 1st value in the filter range to be place at a5, the filtered range starts with a8 (title a7) regards, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to pick the first value in a filtered range - vb code pls
Eddy,
You can use a column of helper formulas. In B8, use the formula =SUBTOTAL(3,$A$8:A8) and copy down to match your column of data in A. Then in A5, enter the formula =INDEX(A7:A16000,MATCH(1,B7:B16000,FALSE)) Change the 16000s to a suitable number for your data set. HTH, Bernie MS Excel MVP "Eddy Stan" wrote in message ... hi Whenever i change the filter a new set of data is shown. I want the 1st value in the filter range to be place at a5, the filtered range starts with a8 (title a7) regards, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to pick the first value in a filtered range - vb code pls
Hi,
Bernie, sorry i am late in thanking. Yesterday & today, i had the same requirement and used the help. best wishes thanks "Bernie Deitrick" wrote: Eddy, You can use a column of helper formulas. In B8, use the formula =SUBTOTAL(3,$A$8:A8) and copy down to match your column of data in A. Then in A5, enter the formula =INDEX(A7:A16000,MATCH(1,B7:B16000,FALSE)) Change the 16000s to a suitable number for your data set. HTH, Bernie MS Excel MVP "Eddy Stan" wrote in message ... hi Whenever i change the filter a new set of data is shown. I want the 1st value in the filter range to be place at a5, the filtered range starts with a8 (title a7) regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pick value off sheet list for VBA code determination | Excel Discussion (Misc queries) | |||
| loop through cells in a range and pick up corresponding cell values in another range | Excel Programming | |||
| look across row - pick highest value - take aplha code of column | Excel Discussion (Misc queries) | |||
| The VBA code for solver does not pick up 'change cells' and 'set . | Excel Programming | |||
| traversing through a filtered range based on another filtered range | Excel Programming | |||
Linear Mode
