pull down to refresh
TIL the excel formula that contain FILTER is available only for Office 365 MSO.
The thing is mi wife have to gather some huge data (like 10k records) from 2 different excels.
If I upload those to google sheet, I cannot construct the formula from 2 different files. One file is also getting some data from another file... is a mess.
In the end I made a temporary copy of the data sheet into destination file and working from google sheets.
In the end I made a temporary copy of the data sheet into destination file and working from google sheets.
That may be the fastest way to go for now.
Does your wife plan to maintain both separate excels in the future? If not, it may be good to just copy the data from the no longer needed Excel into the new one, to keep all the data in one place (assuming the two files are meant to track the same kind of data)
Does your wife plan to maintain both separate excels in the future?
Nah this is just a massive migration data for work. Once the data is already copied in the new format, will be imported in some other database app. Now was just a formatting by specific columns and there were like over 10k lines to verify at hand, pure madness.
That's why she asked me for help to make such formula.
Thanks, you help her and saved a lot of work and possible mistakes by manipulating manually the data.
Will give you more sats, you deserve them.
thanks, that's very generous. hope the rest of the data migration goes smoothly
As long as my wife doesn't bother me with her crap excels I can concentrate more on finishing my BTC guides and help more people with solving BTC issues.
I have quite some people asking me questions about BTC all days long.
So you saved me time looking for that formula and now wife is happy and letting me in peace 😂😂😂
Sats were well spend.
Yeah I saw it, still the same.
Yes, google sheets works !
In that specific picture, the formula is pointing to
$F2but your ID column is onEso it should be$E2. Also, theG$1=...part should sayF. Essentially, your second table is one column shifted to the left from my example.I also tried on google sheet and it should work as long as you fix that error.