I'm now rearranging a sizable number of media files in an effort to make them adhere to a tracking system. I currently have two lists, one of which is a list of all the URLs from which the videos have been ripped.
The names of the.mp4 files from the bulk download are the other.
Column A looks like
Column B looks like:
Column A should be rearranged such that entries correspond to the URLs that contain the filename between /status/ and?s=12&t.
Is that plausible or does it make sense?
XLOOKUP("*/" & f &"~?*",URLs,URLs,"not found",2))
5049 is the sum of all numbers, ...READ MORE
Where the range is multiple cells:
Excel.Worksheet sheet ...READ MORE
So, first with vlookup():
A formula so you ...READ MORE
So I have a hh:mm: ss date ...READ MORE
Hello, yes u can find your birthdate using ...READ MORE
Hi To Calculate the date, we can ...READ MORE
I having a Excel sheet with 1 ...READ MORE
In this case, you can use nested ...READ MORE
The conventional method of obtaining data from ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.