# Search:

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

1. ## Thread: Separating list of text into multiple cells.rows

by Traceelewis71
Replies
4
Views
202

### 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. ## Thread: Separating list of text into multiple cells.rows

by Traceelewis71
Replies
4
Views
202

### 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. ## Thread: Repeat Numbering for like ID's

by Traceelewis71
Replies
4
Views
168

### Re: Repeat Numbering for like ID's

Thank you!!! worked!! :)
4. ## Thread: Repeat Numbering for like ID's

by Traceelewis71
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...

by Traceelewis71
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. ## Thread: Converting horizontal data to vertical data with repeating data

by Traceelewis71
Replies
3
Views
248

### 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. ## Thread: Converting horizontal data to vertical data with repeating data

by Traceelewis71
Replies
3
Views
248

### 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. ## Thread: 2 If then statements

by Traceelewis71
Replies
3
Views
181

### Re: 2 If then statements

So Simple!!!
It worked Thank you!
9. ## Thread: 2 If then statements

by Traceelewis71
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,

by Traceelewis71
Replies
5
Views
122

### Re: Number Formatting

Thank you!!!! That worked.

by Traceelewis71
Replies
5
Views
122

### Re: Number Formatting

I've tried that and its only updating the view not the actual cell contents