Hi! I'm looking to merge/ reconcile two sets of columns and I can't figure out how to do it. Data will either be populated in column A or column B, but never in both. I'm guessing the logic should be as follows:
If column B is populated, column A should equal column B. If column B is not populated, keep Column A as is. Is there a formula to achieve this? Thank you!

Has anyone recently applied and gone through the H1B process at Walmart? or is there anyone in this bowl who is at Walmart currently and had their H1b renewed recently.

anyone else feels stuck at current job, but not able to apply due to upcoming paid maternity leave benefits that you don't want to miss out on? currently still in first trimester !

Job recommendations for someone enjoying TAS (FDD) work, but doesn't want to be as into the weeds/details on the Company's accounting?

What is a look back analysis?

So do higher ups (managers/directors/etc) in FFD talk to each other about the progress of seniors and associates in a similar manner to how the staff are ranked during audit roundtables??

Hello! Need help. I got a letter in mail for Hyundai's car recall and was told to contact nearest Hyundai dealer. Upon calling, I was told that while it's a known recall, there is no remedy for it per the corporate site.

The two doesn't add up. Should I call another dealer? Or is something like this possible? Clearly a novice when it come sto this.

Starting IVF in a month - any guidance in prep for it, things that may help increase success for egg retrieval or anything like that? I started taking supplements advised by my doctor, but curious to hear of anything else! Thank you SO much!

Any recommendations on relocating to Hawaii? I am registered for the Hawaii bar but currently based out of Los Angeles and practicing in California as a licensed attorney.

28M living West Loop- trying to see if anyone wants to grab a drink tomorrow evening! Off for Thanksgiving and client travel immediately after, so would be great to see someone new before I leave the city for a bit.

How do you handle billing disputes? Already feel like we’re a steal compared to other firms, but it’s the pits when clients kvetch about the bill after working hard on their matters. For five figure disputes, anyone recommend collections? Don’t really want to institute retainers, especially since it doesn’t seem common for our practice area.

/x-post from the Consulting Bowl/

Hello, Partners. Can anyone recommend fantastic courses, videos or training for a new manager like myself? I’ve come from a tech background and looking to be C-Suite

I'm moving to London next Month from Newcastle and commuting into the city center, the closest tube station is chancery lane.

I will be getting a base of £42k and was wondering what locations you all would recommend to look for a place in, by the looks of things I will almost definitely be getting a flat share

After HR discussion..how much time HR will take to give the offer letter?

Where my arabs at

How do you judge if a headline is good or not? When I look at lines, I see an idea there but it’s petty straight forward, so I suggest to the writer to add a twist to it. Cont...

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

How long did it take you to become good at excel? Like fast?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

Best websites to get more of a handle on Excel as a beginner-intermediate?

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.