pnuts questions

pnuts answers

• Conditional Formatting with increasing colors
• Adding an Excel Data bar to one cell that is entirely based on the value of another cell
• How to select all columns in a row?
• How to find groups of individuals who attended multiple events together?
• Creating chart of only certain rows
• Union of multiple columns as one column
• Error while calculating maximum value in a series
• Convert multiple value columns into new key, value pairs
• Using SUMPRODUCT with TRANSPOSE
• Using conditional formatting to alternate the formatting of data by category