|
|
#1
03-12-2018, 05:38 AM
|
|||
|
|||
Populate title based on cell comparison
In the attached spreadsheet, I would like to do the following:
if the total in column F is less than column E, populate the title from column C under the "Needed" category in column I. Then calculate and place the Delta for that item in column J. Thank you for your help. 
|
|
#2
03-12-2018, 02:29 PM
|
|||
|
|||
|
I2 =IF(F2<E2,C2,"")
J2 =IF(I2<>"",F2-E2,"") Copy down to end of data
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| is sit possible to auto populate a cell based on dates | wheddingsjr | Excel | 6 | 11-27-2017 11:21 AM |
| Auto populate cell based on certain situations | YW3 | Excel | 10 | 05-26-2017 02:02 AM |
| Populate a table based on choices from drop down menu | Xaand | Word VBA | 0 | 02-25-2014 11:08 AM |
| how to populate textbox based on combobox selection in word | IvanGeorgiev | Word | 1 | 02-21-2013 07:32 PM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Mac OS X 
Office 2016
Linear Mode
