BLACK FRIDAY SALE 20% OFF ALL COURSES

Philip Treacy
Admin

Forum Posts: 1563
Member Since:
October 5, 2010
October 5, 2010

Hi David,
You haven't said what the problem is. Are you receiving an error message?
It works fine for me so I'm not sure what to say.
Maybe reviewing the function syntax will help you figure out whatever issue it is?
https://www.myonlinetraininghu.....r-function
Regards
Phil

Purfleet
England
Member
Members

Trusted Members

Trusted Members

Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019


Purfleet
England
Member
Members

Trusted Members

Trusted Members

Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019

Afraid not.
There are formulas that will do simular but can be fairly complex. Depending how often you will be doing the filter you can just use normal filters or Advanced filters and copy over the data.
Not great but does work
You could create a macro that does a simular thing if you have to do it regularly
Purfleet
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Melissa Jamison, Pam Baillie, Andrew Johnson, Laura Easley, Jacqueline Vickery, Todd Heckman
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1864
SunnyKow: 1432
Anders Sehlstedt: 886
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 241
Hans Hallebeek: 227
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Kelvin H
Anya Ledwith
Mark Melvin
Stuart McInnes
Naji Moukhachen
Robert Mason
Debora Cohen
Kris Whitaker
Rajesh Jawajala
Todd Heckman
Forum Stats:
Groups: 3
Forums: 24
Topics: 6641
Posts: 29140
Member Stats:
Guest Posters: 49
Members: 33096
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
