I have 2 workbooks Linked: Table 1 (Workbook 1) & Table 2 (Workbook 2).
"Declined" items of Table 1 are to be listed in Table 2 (two different, but linked workbooks). So 'Declined' from Table 1 is the main judgement criteria.
1. Formula - Green cell in Table 2 - IF D2 of Table 1 is "Declined"...
Hello I’m having a brain fart lol
I have a 4 column table
Column a dates
Column b the words can be Offer or declined
Column c will contain numbers
Column d will contain various words
I want a formula to look through table and identify the word Offer only and return the total of column c...
Hello, I am no expert with excel so please forgive me if what I'm about to ask is silly. I am creating a canned response tool for my department which allows users to pick which options were used. Currently I have it formatted as a list which works but it's not how I'd like it. I would like to...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.