1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formula to combine values based on other cells' condition

https://preview.redd.it/k9pwcpni17rg1.png?width=983&format=png&auto=webp&s=1d3c398a78910a685194547a74fe63370886974b

Complete noob here, I'm needing help simplifying the results of the attached chart. The goal is to reduce the amount of results as much as possible depending on how many cells in the "color" column are unique, and combining the values in the blue and green columns to the respective color, if any match.

submitted by /u/Big-Eagle56
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#big data management in spreadsheets
#rows.com
#big data performance
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#AI formula generation techniques
#cloud-based spreadsheet applications
#formula generator
#color
#formula
#Excel
#values
#combine
#result
#cells
#unique
#blue column
#green column
#column values