Categorize data

[Belletmns]

Hi Team,

Seeking for your help. I need to categorize the data based on the below condition.

For example: If there is data under Column M &N the type of schedule falls on "Schedule A"

Conditions:

Column M	Column N	Column O	Column P	Type of Schedule
Data Here	Data Here			Schedule A
Data Here				Schedule A
	Data Here			Schedule A
		Data Here	Data Here	Schedule B
		Data Here		Schedule B
			Data Here	Schedule B
Data Here	Data Here	Data Here	Data Here	Schedule AB
Data Here		Data Here		Schedule AB
	Data Here		Data Here	Schedule AB
Data Here	Data Here		Data Here	Schedule AB
Data Here	Data Here	Data Here		Schedule AB
	Data Here	Data Here	Data Here	Schedule AB
Data Here		Data Here	Data Here	Schedule AB

Thanks in advance!

[NexBK]

[Tyro_abc · Accepted solution]

HI

you can use the below formula to derive category

if (
replace([Column M]+[Column N],' ','')!=''  and  
replace([Column O]+[Column P],' ','') ='') then 'Schedule A'

elseif (replace([Column M]+[Column N],' ','')=''  and  
replace([Column O]+[Column P],' ','') !='' ) then 'Schedule B'
else 'Schedule AB' endif

[grazitti_sapna]

Hi @Belletmns ,

Give this a try.

If this helps kindly mark this post as solution and like.

Thanks.

[Belletmns]

Thank you!