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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,910
Messages
6,175,316
Members
452,634
Latest member
cpostell

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