Formulas, Functions, Formatting, Charts, Data Analysis, etc.
by lreaton » Wed Feb 03, 2016 11:46 am
I am working on a project where i am using the IF Function in the last row to calculate information based on two other columns and I i need the end user to be able to insert rows to add additional information and want this IF statement to Auto populate in the Column in the newly inserted row .
How do I do this?
-
lreaton
- Rookie
-
- Posts: 1
- Joined: Feb 3, 2016
- Reputation: 0
- Excel Version: 2007
by pecoflyer » Thu Feb 04, 2016 2:45 am
Hi and welcome to the board.
Just select your range then Insert Table and follow the wizard
A relevant topic title helps get faster and more answers
-
pecoflyer
- Moderator
-
- Posts: 1274
- Joined: Jan 24, 2012
- Location: Belgium
- Reputation: 39
- Excel Version: 2003/2007/2010
Return to General Excel Questions
Who is online
Users browsing this forum: No registered users and 121 guests