| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to find the Row Number of the last repeated row of aparticular date field
I have this Table where the first field is a Date Field where the dates are repeated. Column A 1 14-Aug-2016 2 14-Aug-2016 3 15-Aug-2016 4 15-Aug-2016 5 15-Aug-2016 6 17-Aug-2016 7 17-Aug-2016 8 17-Aug-2016 9 17-Aug-2016 10 17-Aug-2016 11 17-Aug-2016 12 18-Aug-2016 13 19-Aug-2016 14 19-Aug-2016 I need to write a code to get the Row Number of the last repeated Row of a particular date, say for 14-Aug-2016 it would be Row No. 2, for 17-Aug-2016, it is Row No.9... Help please San |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count of times a number is repeated by date? | Excel Worksheet Functions | |||
| Find and Add a number in a text field | Excel Worksheet Functions | |||
| Lookup to find the last value based on name and date field | Excel Discussion (Misc queries) | |||
| How can i calculate the age as on aparticular date on excel | Excel Worksheet Functions | |||
| Trying to SUM up a DATE/TIME field in code... | Excel Programming | |||
Threaded Mode
