Thread: [Solved] Counting populated cells (range) in one column, that fall between 2 (diff) values in another column
View Single Post
 
Old 07-17-2024, 09:44 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
2024-07-17_173726.jpg


or you could use the user interface and go into Add column, then Conditional column and fill in for example as follows:




2024-07-17_174119.jpg


which results in the likes of:

Code:
= Table.AddColumn(#"Removed Blank Rows", "IsHdr", each if [MODULE NUMBER AND PREFIX] = null then false else true)
Reply With Quote