Search:

Type: Posts; User: somanyqs; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. How convert scatter plot to column bar chart (using ranges on x-axis)?

    Hello-
    I currently have a scatter plot that has the price paid for a car (tons of different types of cars with lots of different list and net prices) on the x-axis, and then the y-axis has the...
  2. Re: Any easy way to get data for point on scatter plot?

    Thanks-
    Is there a way to access that label data when hovering/selecting (instead of text always appearing) for very crowded plots? I think the XY Chart Labeler provides text overlay (always)?
    ...
  3. Any easy way to get data for point on scatter plot?

    I have a scatter plot, sale price (x-axis) and discount (y-axis).
    Is there a way to quickly get other information, such as customer name, for that data point? Such as if I select that single point...
  4. How change formatting if a cell is overwritten/change? Or like a forced "track changes"

    Hello all-
    I have an Excel file I share with lots of people, and I have many formula and numbers scattered through (it basically is a sheet to place orders for goods)

    What I am wondering is if...
  5. How can I test Excel file as if opening in Europe with different number format?

    Hello-
    I've made a large Excel file (lots of sheets, lots of complex formula), and when used by others in Europe it changes number formats correspondingly.
    So "," turns to "." for example (where in...
  6. Re: How show and edit page breaks in main window

    Thanks for the tips -
    Unfortunately still no luck. Strangest thing...I don't seem to be able to access the dotted blue lines that should appear in a Page Break Preview, and then drag them to...
  7. Re: How do I delete functions from the ribbon?

    Gotcha - sounds like not possible to remove just one (or a few) buttons from within the ribbon (it does make it a pain when the window is so small some of the buttons I often use are hidden...nuts)....
  8. How do I delete functions from the ribbon?

    This one is driving me batty...
    I am using Office for Mac 2011.
    I would like to, for some of the tabs (ie Home, Layout, Tables, etc.) in the ribbon, change some of the functions that are visible -...
  9. How show and edit page breaks in main window

    Haven't used Excel heavily in a while...now am on Excel for Mac 2011.
    I remember in a much older version I used that I used to be able to set up the view on the screen to show the page breaks - but...
  10. Re: How change multiple cells (with ranges) from relative to absolute references

    Thanks. I think I simplified my question too much, sorry about that! :)
    Unfortunately it is a little more general a problem, so I have cells that are:

    A1= sum(AA1:BA1,CB1:DE1)
    A2 =...
  11. How change multiple cells (with ranges) from relative to absolute references

    I have a whole bunch of cells that are like:
    A1 = sum(B1:Z1)
    A2 = sum (B2:Z2)
    ...
    A100 = sum (B100:Z100)


    I can figure out how to change just one cell (like A1) from relative to absolute...
  12. Re: How change validation range for multiple cells

    Ahh thanks - I realized I needed to 'paste special - values' to get it to work. Thanks!
  13. How change validation range for multiple cells

    Basic one that I would think.
    I have a column so perhaps 100 cells that all use the same validation list. And I have already made selections for all of those cells from the options within the...
  14. Replies
    9
    Views
    1,823

    Re: COUNTIFS with AND or nested COUNTIFS?

    A belated thanks Jonmo1-
    Much helped for what I was doing. Now to go try to remember why the SUMPRODUCT formula logically makes sense...if I can...
  15. Replies
    9
    Views
    1,823

    Re: COUNTIFS with AND or nested COUNTIFS?

    You're welcome.
    I just edited a follow-up with another quick one if you have a sec in regards to if the ingredient columns aren't sequential.
    Thanks again much!
  16. Replies
    9
    Views
    1,823

    Re: COUNTIFS with AND or nested COUNTIFS?

    And thanks for the COUNT(INDEX) answers also - good to know. I never would have gotten these!
  17. Replies
    9
    Views
    1,823

    Re: COUNTIFS with AND or nested COUNTIFS?

    One day I'll remember how to use this SUMPRODUCT...I'm not sure when.
    A follow-up...
    Is there an easy way to modify for when the columns are not consecutive? So when I need to check ingredients...
  18. Replies
    9
    Views
    1,823

    COUNTIFS with AND or nested COUNTIFS?

    My brain is jamming a bit to start the day.
    I'm trying to make a formula that given one cell, checks if that , counts how many times other cells in that row are >1.

    So for example,
    A1 = Bob [or...
  19. Replies
    1
    Views
    529

    Re: Struggling with MEDIANIF, get #NUM!

    I should add, when I do an AVERAGEIFS, I can get the formula to work fine...which makes me thinking I'm missing something even more basic! :-O
  20. Replies
    1
    Views
    529

    Struggling with MEDIANIF, get #NUM!

    On Excel for Mac 2011

    I have a median if array (am using C-S-E) that works for about 5 of my criteria, but when I add in my last criteria, it goes to #NUM!.
    I know I am missing something basic,...
  21. Re: Can I use > to compare dates within a COUNTIFS (or SUMPRODUCT maybe?)

    Since the final DATE(2013,1,1) isn't actually fixed, but it is dependent on the other dates for sales to the same company, if there is a way to capture that component and compare them?

    So the...
  22. Can I use > to compare dates within a COUNTIFS (or SUMPRODUCT maybe?)

    A twist on an earlier post (wanted to post separately so not to mix everything into one...)

    I have a list with companies, purchase dates, and what widget they purchased.
    And also a flag for if...
  23. Re: How "sum" text in cells across rows – SUM, IF, FREQUENCY?

    You guys rule
    Matty +1
    ArthriticPanda +1

    Getting Excel work completed in time for upcoming weekend +1
  24. How "sum" text in cells across rows – SUM, IF, FREQUENCY?

    My head is starting to hurt...feel like this one should be easy but I can't figure it out!

    I have a list rows with companies, purchase dates, and what widget they purchased.
    And also a flag for...
  25. Re: Vlookup with ifs to compare cells in different rows based on conditions?

    Aladin and Akashwani...fabulous! Thank you!
    I think from these I should be able to modify my work (and learned quite a bit here), much appreciated-
Results 1 to 25 of 76
Page 1 of 4 1 2 3 4