Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GlasgowSwan

    [Excel] - Y Axis Scale

    Found the solution: Select the Y axis Choose Format, Format Selected Axis Select the Number tab Under Category choose Number Change the decimal places to 0
  2. GlasgowSwan

    [Excel] - Y Axis Scale

    I have data that is displayed in a graph. The data does not have much of a range of values. For example 1, 2, 3 4. When the chart is displayed the Y axis is 0.5 ,1 ,1.5, 2, 2.5 etc... How would I change the Y axis to whole numbers eg, 1,2,3 etc,,
  3. GlasgowSwan

    [Excel] - Count

    Many thanks, this worked
  4. GlasgowSwan

    [Excel] Count and Null Dates

    Many thanks this worked
  5. GlasgowSwan

    [Excel] Count and Null Dates

    Skip I have changed the criteria. However if I change < to > it does not include the blank cells
  6. GlasgowSwan

    [Excel] Count and Null Dates

    Thanks for the help so far. The first part of the formula is fine however the formula posted by Glenn lists all which had been sold before the date and all blanks. I need all after the date and blanks.
  7. GlasgowSwan

    [Excel] Count and Null Dates

    A B C D 1 Type Colour Sold On 2 Car Red 01/01/2008 3 Car Red 4 Bus Red 01/01/2008 5 Car Green 6 Bus Green 7 Car Red 10/01/2008 8 09/01/2008 I would like to count all of red cars...
  8. GlasgowSwan

    [Excel] - Count

    A B 1 car red 2 bus red 3 car green 4 car red I would like to count the number of red cars in the grid. Could someone help with a formula? (i have used the above as an example however the really one is likley to have hundreds of rows) Thanks

Part and Inventory Search

Back
Top