Auto populate Reason Column Based Critera

nf1del83

New Member
Joined
Feb 21, 2016
Messages
5
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Reason[/TD]
[TD]Wave[/TD]
[TD]Short[/TD]
[TD]Hem[/TD]
[TD]Use[/TD]
[/TR]
[TR]
[TD]Blocking, Short, Sticking Hem[/TD]
[TD]Bloc[/TD]
[TD]Burn[/TD]
[TD]Stic[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Hem[/TD]
[TD]Inc[/TD]
[TD][/TD]
[TD]Burn[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Short, Hem[/TD]
[TD][/TD]
[TD]Weak[/TD]
[TD]Inc[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]


I want to have the "Reason" Column (approximately a few hundred rows a day) automatically populate based on the values of certain cells. I added a table above for reference of what I am trying to accomplish. If there are values in the Wave, Short, Hem, or Use Columns, those will all need to be shown in the Reason Column, separated with a comma and space as demonstrated above.

A few tricky parts:

  • For "Wave", I want the "Reason Column" to display "Wave" only if "Bloc" is in the "Wave Column"
  • For "Short", anything that is not blank will result in "Short" being displayed in the Reason Column.
  • For "Hem", if the value equals "Stic", I want the reason to show "Sticking Hem". If it has any other value that is not blank, I want the reason to only show
  • For "Use", if the value is any number greater than 2, I want Reason to be shown as "Short", but only if it does not already state short from previous entries


I greatly appreciate the guidance!
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

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.
Go back
Back
Top