Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo
Posting as :
works at
You are currently posting as works at

Stop what you’re doing now. Instead, have a lookup table with the product to name matching logic and then use that to fill in your names in your main dataset.

like

This one ^

Don't have an elegant solution but you can copy what you have to a new tab, delete all blanks in the right column, remove duplicates and then run a vlookup off of your new tab into all the blank cells of the original tab by filtering for blanks and copying the formulas to all blank cells.

likesmart

Copy (Ctrl -C)the value you want in all the other cells. Highlight all the cells you want to fill with that value, Ctrl+G, Special, select visible cells only, Ctrl+C and Done. Don’t over complicate it!

like

This is the way. The Ctrl+G selecting specials is a game changer.

Would recommend lookup table as someone else did on the three but also could probably goto home> find and select> go to special and select blanks> then “=select cell above” and CTRL+Enter. If you have the first Name filled in for each ID it will fill in the blanks with cell above

like

Power query > fill down

like

MUFG?

like

Create a new column (column C) after the names (column B) and on the second row write =IF(B2=“”, B1, B2)

Related Posts

Amazon is hiring a lot of migration specialist ,could anyone refer me ? Also what is the package they offering

like

Hi All

Need career guidance
Qualifications: b.com graduate; MBA in Finance and Marketing
Campus Hire at Deloitte
Profile: Engagement Financial Advisor
Years of experience 4 years

Please guide

like

Can anyone refer me in Wipro. Thanks in advance.

Getting into the military helped my feeling of abandonment due to my father's absence. It sounds funny, but being in the military showed me another type of parenthood that I needed.

like

Love to see Duke lose

like

Hows the industry doing in MENA right now? Any worries about a potential crash? Are firms still hiring? Based in the US and everything is tense here with the recent tech layoffs

like

Hi Scholars, can some one guide on below salary breakup what would be the total in hand salary.

- 80CC is applied for 1.5 lakh per year
- For HRA calcuatio6Per month rent is 30k

Post Photo
like
like

Best neighborhoods in Jersey City for starting family soon?

like

Loving the green

Post Photo
like

Can anyone please share working experiences till now working with Deloitte India? Deloitte Deloitte India

like

Outside counsel has been prepping company witnesses for a trial in August. It is my subject area so I am supervising outside counsel. I did not, however, choose the counsel. He is doing a really awful job. Co counsel is better, but not great either. Higher ups love the firm… I do not want to micromanage, but I have genuine concerns about outside counsel’s ability to try this case. Trials are rare, and I just don’t think these guys have actually tried many cases. Cont. below…

like

This photo made me laugh way more than I should have.

Post Photo
likefunny

Can someone please help me to decide between Zee entertainment enterprise ltd and Deloitte for 3 YOE in NodeJs Developer ?

likeuplifting

I am considering moving from US to Canada within EY if my visa doesn’t work out. Joined EY TAS- OTS from MBA as a Senior last year with base of 150k. How much salary should I expect in Toronto?

how do you deal with work when you’re having a flare up?

how much do you tell your co workers/managers?

like

Hi fishes.
Can anyone please help me understand if BNP Paribas Mumbai provide relocation benefits to outstation joiners?
What are their relocation benefits? Do I need to ask for it or is it a part of your joining benefits?

How can I improve my attention to detail? I need help

Thoughts? What could be going on here?

Post Photo
like

Has oracle ever revoked offer letter at time of joining?

like

Additional Posts in Excel Genius

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

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What are your top Excel ninja tricks? Ones that few people know...

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

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

like

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

like

Any book recommendations on excel modeling for real world business applications?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

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 🙏

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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?

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal