gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
Want to keep the listing 'static' or not rearranging the list, its still correct, but rearranged.
When I save the workbook, it rearranges the list.
Want to keep the listing 'static' or not rearranging the list, its still correct, but rearranged.
When I save the workbook, it rearranges the list.
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:D2 | B2 | =LOOKUP(2, 1/((COUNTIF($B$2:B2,Favs!$A$4:$A$29)=0)*(Favs!$A$4:$A$29<>"")),Favs!$A$4:$A$29) |