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

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

Not enough here to help you.

Is this why it’s taking 6 months for my car to be built and delivered?

likefunny

Keep up the good work young buck :)

Yep, you can do it with a formula. In the next column you can use (assume your first data point starts on A1 and your first value in new column is =A1) =If(A2=“”, B1,A2), ie you’re telling it to return the value if it’s not blank and the above info if it is.

like

Isblank is a newer function you can use instead of A2=“”

What do you mean by fill?

Like, fill the same value of the cell above untill once cell has a value written? And then you fill the ones below that with its value?

I thought I saw a flash fill feature somewhere which I assume would do it, but haven't tested. Alternatively, you can highlight the entire used range. Then F5 > Special objects > select blank cells. Once all blank cells are selected, type in = and point to the cell above the active cell. Hit ctrl+enter. That should fill every blank cell with a formula that points to cell above.

Related Posts

Hi all, I was told that my business unit is Finance Risk and Control in JPMC. My profile is Java Fullstack developer. Can anyone help me about this unit ?

like

Hi Guys can anyone refer me for the position of data and analytics analyst Job Identification NO :210362477..THANKS IN ADVANCE!

like

22- Asked to upload document in ibegin
23- Verified all documents
What next ?
Current status as show below on ibegin

Post Photo
like

The worst place to work as RN is HCA Largo Hospital, FL

like

My practice got super busy after the pandemic. I have had a waitlist and been incredibly busy. It’s been stressful, but I have been grateful for business & to be helping people through a crazy time. This fall, I’ve noticed things slowing down and I don’t really know why. Has anyone else seen any similar trends (or know what might be going on)? TIA.

like

Hi all, my aim is to join one of the faang companies after two years. I want to dedicate these two years to attain whatever knowledge ia required. My skillset is currently java, springboot thats all. What i need to prepare to get into one of these top companies. Can someone elaborate the required skillset and how many interviews and what kind of interviews and so on.

like

What is KPMG’s most prestigious advisory practice?

like

Hello Fishes,

What is the official notice period in walmart?

like

Hi fishes!
Anyone knows how's the working
environment in Amdocs Pune NEO unit ?
TIA

like

Any tips on starting a side project to boost my chance of getting hired as a PMM?

like
like

How we feelin about distressed jeans? 🤔
*ordered by accident and can't return* srs
-Peter Millar polo
-Charlotte Russe jeans

Post Photo
funnylikeuplifting

Has this ever happened to you that each time you meet your bf/gf , there is extreme nervousness from both sides ? It’s a good kind of nervousness (shyness , awkwardness) and almost feels like meeting someone you have known forever for the first time?

like

Is Art Director’s Club (ADC) worth submitting work into for their awards show? I know its not on the scale of Cannes or D&AD.

Can anyone please refer me.
Tech stack - .Net Core + Angular/React
YOE - 3.5
NP - 1 month

Hi folks,
I am working as a Business Analyst with 3.5 YOE and in total 4.9 YOE. I am getting 6.7CTC which felt totally low. If I switch then how much I can expect as a market standard currently. Thanks

like

I don’t play with options much, but I happened to buy VERU calls for 2/19 a little while ago and now it’s skyrocketing, it’s up over $1k for me- will it keep going up? Should I just take the profits now and be happy?

like

Trying to laterally move to another in house position. At my current company, Counsel is a Manager level position while Senior Counsel is a Director level and General Counsel is Senior Director. Would like to find if Counsel is a Director role at other companies.

like

Additional Posts in Excel Genius

Would anyone be willing to teach me vlookup?

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

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

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

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

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.

likefunny

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)

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

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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 😭

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?

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

like

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

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
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

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

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!

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

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