Hi Excel Gurus,
I am in need of assistance with coming up with either regular excel formulas or VBA Macro(s).
I’m average when it comes to formulating regular excel formulas.. like Countif and such.. but when it comes to trying to do the tricky things like searching a list for a number in a line/list of numbers in order by date, and copying that date and the associated string of numbers to a different location or sheet, well, that’s where I become lost.
And worse yet with VBA.
For example:
7/1/2020 8 11 21 39 50 1
7/2/2020 1 7 10 15 35 3
7/3/2020 12 16 24 41 60 4
7/4/2020 1 13 30 44 57 1
The strings of numbers would look like the above string… there are many strings of numbers in the list.
So, say I’m searching for all strings that start with the number 1, I need help with formula or macro that would find all strings of numbers starting with #1 and returning the date and the string on a different sheet.
in this case two strings would be copied to a different sheet.
I am uploading an example spread sheet, with more detailed instructions.
Thank you in advance… I really do appreciate your help with this.
Dave
I am in need of assistance with coming up with either regular excel formulas or VBA Macro(s).
I’m average when it comes to formulating regular excel formulas.. like Countif and such.. but when it comes to trying to do the tricky things like searching a list for a number in a line/list of numbers in order by date, and copying that date and the associated string of numbers to a different location or sheet, well, that’s where I become lost.
And worse yet with VBA.
For example:
7/1/2020 8 11 21 39 50 1
7/2/2020 1 7 10 15 35 3
7/3/2020 12 16 24 41 60 4
7/4/2020 1 13 30 44 57 1
The strings of numbers would look like the above string… there are many strings of numbers in the list.
So, say I’m searching for all strings that start with the number 1, I need help with formula or macro that would find all strings of numbers starting with #1 and returning the date and the string on a different sheet.
in this case two strings would be copied to a different sheet.
I am uploading an example spread sheet, with more detailed instructions.
Thank you in advance… I really do appreciate your help with this.
Dave