Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    104

    Re: Multiple CountIfs

    Thank you Joe4 and Fluff! Both your solutions worked, and saved me a ton of time. Thank you both!
  2. Replies
    4
    Views
    104

    Multiple CountIfs

    I have a large spreadsheet (to ER3500) and need to count specific columns with non-blank cells across the rows. I have tried several CountIf and CountIfs, but I can't get there. A sample spreadsheet...
  3. Replies
    1
    Views
    104

    Link tabs to original data?

    I have a master spreadsheet (Tab 1) which goes to cell EM:3500. The boss filters for specific data, copy/pastes the filtered data to another tab and then runs calculations. This easily results in 20...
  4. Replies
    5
    Views
    200

    Re: Vertical source data to horizontal table?

    Thank you both! However, I know very little about VBA or Power Query.
    MickG – I received an error message pointing to the first line of the code. How can I fix this?
    Sandy666 – Can you point me to...
  5. Replies
    5
    Views
    200

    Vertical source data to horizontal table?

    My source data includes File #, Name and Title. There are up to 10 Name/Titles associated with each File#, and the Names are often repeated with a different Title in each File. I need to show all...
  6. Re: Looking for a formula to insert column header text

    Thank you both! They are wonderful (and easy) solutions!
  7. Looking for a formula to insert column header text

    I must compile over 60 multipage paper surveys. The 1st question has 20 possible responses and the users marked all that applied. The easiest method I can come up with is to "x" the appropriate box...
  8. Replies
    5
    Views
    227

    Re: Autopopulate column after dropdown?

    My apologies! I was so focused on finding a solution I didn't even think about cross-posting. I will remember in the future.
  9. Replies
    5
    Views
    227

    Re: Autopopulate column after dropdown?

    Thank you!
  10. Replies
    5
    Views
    227

    Autopopulate column after dropdown?

    I have a list of states and their counties. I'm looking for a method to choose a state from a dropdown and a column of their associated counties appears. Or, if the user types in the 2 letter state...
  11. Replies
    3
    Views
    171

    Re: Keep font size in concatenation?

    Thanks Fluff. I thought it might not be possible.
  12. Replies
    3
    Views
    171

    Keep font size in concatenation?

    The font size in one column of my data is different from the others. How can I keep the correct sizes when the data is concatenated?
    Thanks!
  13. Replies
    3
    Views
    341

    Re: Create two data labels in pie chart?

    Thanks for responding Paul. When I Format Legend Entry/Picture Fill, the result is the image in the pie slice, not the Legend. Is there some other way to make this work?
  14. Replies
    3
    Views
    341

    Create two data labels in pie chart?

    The boss wants an icon in each data label of a 6-slice pie chart. I can insert the image into the label but it often covers the text and value. Can I create a label for text/value and a second for...
  15. Replies
    2
    Views
    522

    Re: Ignore formula if cell is blank?

    Kroneborge, I plugged in your formula, replacing targetCell and mycurrentformula but it resulted in #NAME . Is there another way?
  16. Replies
    2
    Views
    522

    Ignore formula if cell is blank?

    Help please. The source data in spreadsheet #1 is linked to spreadsheet #2 by formulas. Pie charts are created from spreadsheet #2 .
    The problem is the blank cells in #1 appear in #2 as 0%...
  17. Replies
    0
    Views
    153

    Doughnut Chart with Image or Icon?

    I've been told to add images to a Doughnut chart with Category Name and Percentage for 50 reports. How can I add an image or icon linked to the Category Name?

    Will it work with icon sets? If so,...
  18. Replies
    0
    Views
    102

    Merge Pie Charts to Word or Publisher

    I'm merging Excel data to either Word or Publisher to create a set of reports. Each report includes a pie chart. I'm trying to avoid copy/paste. Can the already created chart be merged to the report?...
  19. Replies
    5
    Views
    458

    Re: Merge Custom Format $14.9M to Word?

    Thank you Joe4. It worked wonderfully!
  20. Replies
    5
    Views
    458

    Merge Custom Format $14.9M to Word?

    I have a column of dollar amounts in the millions. Using Custom Format $14,920,569 now appears as $14.9M. However, when I merge to a Word doc the formatting disappears and just the eight numbers...
  21. Replies
    4
    Views
    404

    Re: Gantt – color change

    thissoldman - you are GOOD! A simple and beautiful solution, thank you!
    I'm gonna pitch all my messy bar charts now.
  22. Replies
    4
    Views
    404

    Gantt – color change

    I’m looking for a way to easily see the task overlap per person in a gantt chart. How can I change the colors in the bar chart to match the color of the staff person assigned the task? Or is there a...
  23. Re: Conditional Formatting: Change color next column

    Thank you Scott T. Just what I needed!
  24. Conditional Formatting: Change color next column

    I used Conditional Formatting to color code the Task List by Due Date (overdue, last week, this week, next week). How can I use it to remove the colors when any text is placed in the Completed...
  25. Re: CountIFs with multiple criteria and duplication

    J2 worked. Thank you!
    I need to learn more about arrays.
Results 1 to 25 of 60
Page 1 of 3 1 2 3