Forum home » Delegate support and help forum » Microsoft Excel Training and help » HOW TO BREAKDOWN DATA

HOW TO BREAKDOWN DATA

ResolvedVersion 2010

Tue 15 Nov 2016, 16:10 Delegate H said...

H has attended:
Excel Intermediate course

HOW TO BREAKDOWN DATA

HOW DO I BREAK DOWN DATA INTO FILTERS SHOWING HOW THAT DATA WAS MADE UP

Wed 16 Nov 2016, 16:59 Trainer Doug said...

RE: HOW TO BREAKDOWN DATA

Hi Howard

Can you say more about what you are wanting. It sounds like you wanting to use a data validation drop down list first to choose an item. Then have data change according to which item is chosen. Would that be helpful to see?

Doug
STL

Training courses

98.5 % recommend us

More live stats...

Training information:

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips