reply on: I need an Excel formula \ stacker news ~devs

pull down to refresh

21 sats \ 6 replies \ @SimpleStacker 16 Dec \ parent \ on: I need an Excel formula devs

In that specific picture, the formula is pointing to $F2 but your ID column is on E so it should be $E2. Also, the G$1=... part should say F. 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.

30 sats \ 0 replies \ @DarthCoin OP 16 Dec

Yeah I saw it, still the same. Yes, google sheets works !

0 sats \ 4 replies \ @DarthCoin OP 16 Dec

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.

2000 sats \ 3 replies \ @SimpleStacker 16 Dec

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)

1 sat \ 2 replies \ @DarthCoin OP 16 Dec

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.

0 sats \ 1 reply \ @SimpleStacker 16 Dec

thanks, that's very generous. hope the rest of the data migration goes smoothly

30 sats \ 0 replies \ @DarthCoin OP 16 Dec

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.