Excel: Group by column and Check if another Column contains a value higher or lower than 3-CodePudding

Home > other > Excel: Group by column and Check if another Column contains a value higher or lower than 3

Excel: Group by column and Check if another Column contains a value higher or lower than 3

Time：06-21

I have an excel spreadsheet where I would like to create a second grouping depending on what value is present in the current group.

I would like to group column A and within each of those group check if a value in Column H is lower than 3.0 and if so have the Cell in Column Q be the Value 1. If not have the Cell have the Value 2.

The out come would be each grouping that have a value under 3.0 would be in group 1 and the rest would be in group 2

Page link：https//www.codepudding.com/other/448713.html

Prev:How to count combination results and place in seperate table using Power Query

Next:Remove email from an Excel cell

Tags：

excel

excel-formula

Links：
CodePudding