Hi this should be pretty simple using Vlookup/other formula. But i just can't remember how to do it. I want to find multiple instances of the same table:
Risk Dependancy
1 D1
2 D2
3 D1
4 D5
5 D7
6 D3
7 D8
8 D3
9 D4
10 D1
So i want to see D1, is associated with 3 risks = #1, #3 & #10. And so on down the list of dependancies.
Thanks in advance.
Add filter to first row and filter out D1 (or anything you like).
Never use Merged Cells in Excel
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Find the attached sheet to see the formula based solution.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Re: Find 2nd, 3rd, 4th instance in list
thanks everyone.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks