Posted November 28, 2019 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 More sharing options... Link to post Share on other sites More sharing options...
Posted November 28, 2019 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 More sharing options... Link to post Share on other sites More sharing options...
Posted November 28, 2019 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 More sharing options... Link to post Share on other sites More sharing options...
Posted November 28, 2019 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 More sharing options... Link to post Share on other sites More sharing options...
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 accountSign in
Already have an account? Sign in here.
Sign In Now