Jump to content

Excel Help

GeorgeKellow
By GeorgeKellow
in Programs, Apps and Websites
 Share
Posted

Hi Everyone 

 

Looking for a bit gudenice with Excel. I have a spreadsheet that I want a few fields to auto populate when new data is added. Could someone show me how? 

 

Many thanks 

George

Link to comment
Share on other sites
Link to post
Share on other sites
Posted

Could you elaborate a bit on what you want to exactly do?

You can make an in a cell in column B if-statement that does something when there is data in the cell in column A next to it. But if that is really what you want, depends on what you are going to do.

"We're all in this together, might as well be friends" Tom, Toonami.

 

mini eLiXiVy: my open source 65% mechanical PCB, a build log, PCB anatomy and discussing open source licenses: https://linustechtips.com/topic/1366493-elixivy-a-65-mechanical-keyboard-build-log-pcb-anatomy-and-how-i-open-sourced-this-project/

 

mini_cardboard: a 4% keyboard build log and how keyboards work: https://linustechtips.com/topic/1328547-mini_cardboard-a-4-keyboard-build-log-and-how-keyboards-work/

Link to comment
Share on other sites
Link to post
Share on other sites
Posted

Formulas that reference the cells as variables

 

But it really depends on what you want help with specifically

Community Standards || Tech News Posting Guidelines

---======================================================================---

CPU: R5 3600 || GPU: RTX 3070|| Memory: 32GB @ 3200 || Cooler: Scythe Big Shuriken || PSU: 650W EVGA GM || Case: NR200P

Link to comment
Share on other sites
Link to post
Share on other sites
Posted

Ended up helping OP in a private message. This was the formula needed at the end: 

=IFERROR(IF(AND(SUMPRODUCT(--ISNUMBER(C11:G11)),NOT(SUMPRODUCT(--(C11:G11<>""))=0)),D11-C11-E11-F11-G11,""), "Data is not correct")

This checks if all the applicable cells can be counted up + have data in them.

If it gives an error, there's incorrect data. If it gives a number, that's a valid result. If it's blank, there is no data yet.

"We're all in this together, might as well be friends" Tom, Toonami.

 

mini eLiXiVy: my open source 65% mechanical PCB, a build log, PCB anatomy and discussing open source licenses: https://linustechtips.com/topic/1366493-elixivy-a-65-mechanical-keyboard-build-log-pcb-anatomy-and-how-i-open-sourced-this-project/

 

mini_cardboard: a 4% keyboard build log and how keyboards work: https://linustechtips.com/topic/1328547-mini_cardboard-a-4-keyboard-build-log-and-how-keyboards-work/

Link to comment
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programs, Apps and Websites

×