Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Formula(?) to create a ranking + a count of the values in a column?

    Hi there, and thank you in advance! I really, really appreciate this forum! :)

    I have data which was not set up in an easy manner to pull information from, so I would love to see if this is...
  2. Re: Rows of comma-delineated numbers, possible to rank in order of appearance?

    Oh thank you again! :)

    I think you are indicating that this NEEDS to be done in two steps?

    Is it not possible to get your result reference just one column of comma-delineated number strings?...
  3. Re: Rows of comma-delineated numbers, possible to rank in order of appearance?

    AlanY -- Gosh, I loved that crafty idea. ... Unless there is a manner of setting COUNTIF() as a delimiter in the Text-to-Column Data treatment option that is outside of the Text-to-Column data ......
  4. Re: Rows of comma-delineated numbers, possible to rank in order of appearance?

    AlanY -- thank you!! No, I am an Excel Dunce, so do not know the "text-to column function," but will look it up and see if I can make sense of it now. :)
  5. Rows of comma-delineated numbers, possible to rank in order of appearance?

    Dear friendly Excel-experts,

    I have mostly manually compiled a column of comma-delineated numbers, in column R. So my data looks like this:

    P----------Q----------R----------...
  6. Re: Find text in one column = add "#, " to different column?

    Here is my data, almost literally:
    Columns and data (ea column is 100px wide, like almost, below!), in NOW state:
    A--------B--------C--------D--------
    word

    Columns and data, in DESIRED state:...
  7. Re: Find text in one column = add "#, " to different column?

    SHOOT! THAT did not work at all!! I'll try again, data is this:

    Columns and data (ea column is 100px wide, like almost, below!), in NOW state:
    A--------B--------C--------D--------
    word
    ...
  8. Re: Find text in one column = add "#, " to different column?

    Snakehips, good morning!

    I have an alternative, which I can use just the same, it'll just take longer but not terrible. (Better than manually!)

    Here is my data, almost literally:
    Columns and...
  9. When "word" is in A1, put a number 5 in C1, etc. (Rows need to align)

    I am hoping that this is possible + easy! :) I am Excel-challenged.

    I have a bunch of data. Certain words appear in various columns. I'd like to be able to direct Excel to:


    If "word"...
  10. Re: Find text in one column = add "#, " to different column?

    Okay, sleeping Snakehips, there was a column between "tags" col 1 and col 2. After deleting that and trying again, I get this:

    Run-time error '13':

    Type mismatch

    *I hope this is somehow an...
  11. Re: Find text in one column = add "#, " to different column?

    Okay, Snakehips Tony -- nothing happened at all. ... I'm sure I did it wrong. What is "it"?
    Thank you!! :)
  12. Re: Find text in one column = add "#, " to different column?

    Hi Shakehips! :)

    Any tips about where I make the substitutions in what you've sent, regarding the col A rows, and col B and C contents? Thank you, Tony!
  13. Find matching data in 2 wkshts, copying/pasting data from same-row col P to the others col P

    I have two worksheets' data. Worksheet Tags. Worksheet Records.

    Only Worksheet Tags has data in col P.

    Worksheet Tags has only SOME of the same data in col A that Worksheet Records has in col...
  14. Re: Find text in one column = add "#, " to different column?

    Snakehips, Tony, thank you so much for this! If only I understood how to use this... I'm not sure I feel secure understanding it clearly enough to see where I need to make substitutions so it can...
  15. Re: Find text in one column = add "#, " to different column?

    @Snakehips -- thank you for your response! :-) I'm so grateful for your query; I just hope I will understand your answer (not terribly Excel-savvy, lately, need to catch up!)

    What is the likely...
  16. Find text in one column = add "#, " to different column?

    Hello Excel experts... I thank you in advance! :-)

    I need to find words in column U, and if found, add comma-space-assigned number in column R (in same row).
    (without disturbing content...
  17. Re: Possible to find frequency of words used in a worksheet, sans specifying any word to be found?

    Thank you!!

    Initially I'd like to find words.

    However, could this be modified to find most-used phrases -- both specified + not specified?

    Thank you!!! :)
  18. Possible to find frequency of words used in a worksheet, sans specifying any word to be found?

    I have a worksheet full of data, across which I'd like to see what words are used most often in it?

    Then to see all results, from most frequently used, to least frequently used words?

    *I'd...
  19. Is there a way to count the most frequently used words in a worksheet? And also to add 3 words to either side, and to be able to see how many times this phrase appears in the worksheet???

    I have a worksheet full of data, across which I'd like to gauge what words + 3 words on either side appear most frequently in that set of data.

    To begin, I'd like to see what words appear most...
  20. Re: Finding most common words in column WITHOUT specifying what words

    Hi, this is awesome! I am wondering if there is a way to do this, and ADD a few words found on BOTH SIDES of the the words found... would that be possible somehow? (My guess is yes, but... how?)
    ...
  21. Re: Two lines of text using alt+enter for the line break: whether text wrap is checked, am I forced to merge cells?

    Thank you, Rick! Shoot... I was just being optimistic that Excel might have allowed such a thing these days. I appreciate your double-response, Rick. :)
  22. Two lines of text using alt+enter for the line break: whether text wrap is checked, am I forced to merge cells?

    Hello, thank you so much for the help that's so kindly given here always! :)
    I want/need to do something so simple, it's got to be possible.

    Whether I have text wrap selected in Format Cells or...
  23. Unable to copy from a worksheet to paste NOT into A1 on another worksheet

    I've divvied up data sorted by a column, so it could be divided by rows, and assigned to several people to analyze. I put each person's data into their own worksheet. We used a shared Excel doc via...
  24. Newbie query: How to get Salesforce data into Excel? I have only a link to the SF report...

    I'm sorry. I have a link to a Salesforce report which I need to copy or import data from and ideally to use/paste into Excel, or something accessible.

    If anyone has any tips, I'd be very grateful...
  25. Re: Hopefully very easy question re numbering rows, starting at 1, but on different rows than 1/top

    Thanks, though I'm not sure I was clear.

    I do not need to drag the numbering down further for more data to be numbered by row.

    The data I need to be numbered does not start on Row 1 of the...
Results 1 to 25 of 147
Page 1 of 6 1 2 3 4