Search:

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

Search: Search took 0.00 seconds.

  1. Re: Separating list of text into multiple cells.rows

    Thank you both!! I was trying to rewrite the report with a calculation to separate the field in the report in our system.

    Dante!! This worked Thank you!!
  2. Separating list of text into multiple cells.rows

    I have a list of positions for employees that are in one cell that I needs to be in rows for each employee. Text to column doesn't work and neither does any sort of text formula like =left, =mid,...
  3. Replies
    4
    Views
    168

    Re: Repeat Numbering for like ID's

    Thank you!!! worked!! :)
  4. Replies
    4
    Views
    168

    Repeat Numbering for like ID's

    Hi, I have id's numbers that repeat and i need to count them with the same "row number" the formula I've come up with is: =if(b2=b1,"1",a1"+1"). each change in employee number it starts over to row...
  5. Replies
    1
    Views
    152

    Index match

    I dont know what ive done wrong to my index match statement. I need to get monthly earning into a column. each person has 12 months in a row. On a separate spreadsheet I have the dollar amounts...
  6. Re: Converting horizontal data to vertical data with repeating data

    THANK YOU SO MUCH!!! That worked perfectly! I'm going to find a class on Macros
  7. Converting horizontal data to vertical data with repeating data

    I currently have a report of 8000 plus employees who have 12 rows of data each. each row of data has 3 columns that are represented for each month of the year. This is how my current reporting...
  8. Replies
    3
    Views
    181

    Re: 2 If then statements

    So Simple!!!
    It worked Thank you!
  9. Replies
    3
    Views
    181

    2 If then statements

    I want to create 2 if-then statements and if the 4 cells match it returns a value of Yes, if not then No
    what am I doing wrong
    =IF(AND(F4=Q4),IF(AND(H4=S4),YES))

    Thanks,
  10. Replies
    5
    Views
    122

    Re: Number Formatting

    Thank you!!!! That worked.
  11. Replies
    5
    Views
    122

    Re: Number Formatting

    I've tried that and its only updating the view not the actual cell contents
  12. Replies
    5
    Views
    122

    Number Formatting

    I have a spreadsheet with over 74K lines and I need 1 of my columns be a hard (absolute) number out to 2 places after the decimal point. for example. If I have 24 in a cell, I need it to be 24.00. ...
Results 1 to 12 of 12