# Search:

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

Page 1 of 6 1

1. ## Thread: how to best summarize this in a pivot table?

by Aryatect
Replies
3
Views
135

### Re: how to best summarize this in a pivot table?

It should work in compact form also, key was putting filter on postal code column.

Glad could help and thanks for the feedback :)
2. ## Thread: how to best summarize this in a pivot table?

by Aryatect
Replies
3
Views
135

### Re: how to best summarize this in a pivot table?

Hi, top or bottom 10 or 2 in the example below (not percent) can be attained using filter on Postal Code for top or bottom 10 this will yield you below results.
...
3. ## Thread: Count If with same keywords

by Aryatect
Replies
5
Views
83

### Re: Count If with same keywords

Glad could help and thanks for the feedback!
4. ## Thread: Count If with same keywords

by Aryatect
Replies
5
Views
83

### Re: Count If with same keywords

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
5. ## Thread: Count If with same keywords

by Aryatect
Replies
5
Views
83

### Re: Count If with same keywords

Hi, From the problem you described below should work:

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
6. ## Thread: Auto selected based on DOB

by Aryatect
Replies
3
Views
132

### Re: Auto selected based on DOB

Changed a formula a little different, see if this works:

=IFERROR(INDEX(\$A\$2:\$A\$16,MATCH(IF(DATE(YEAR(E2),MONTH(E2),1) >=...
7. ## Thread: Trying to convert m/dd/yyyy to mm/dd/yyyy

by Aryatect
Replies
7
Views
92

### Re: Trying to convert m/dd/yyyy to mm/dd/yyyy

Hi, 2 ways:

1. Go to Number Format and change to mm/dd/yyyy
2. If number stored as text is ok then =TEXT(A1,"mm/dd/yyyy")
8. ## Thread: Calculating percentages - error

by Aryatect
Replies
1
Views
78

### Re: Calculating percentages - error

Hi, you are changing from 0 to 1 which means it as per your formula 1/0 which is infinite and not 100%. You can default it to 100% by =IFERROR(U3/V3-1,1) but you have to note that if it changes from...
9. ## Thread: Average or occurrences help needed

by Aryatect
Replies
7
Views
221

### Re: Average or occurrences help needed

if the understanding from post #6 is correct then below should work (Showing only part of data):

10. ## Thread: Average or occurrences help needed

by Aryatect
Replies
7
Views
221

### Re: Average or occurrences help needed

So in the example you gave, occurrences should be 4 right row 2 to row 15 - 1st , then row 26 - 2nd occurrence , then there is a gap of row 27 and hence row 28 - 3rd occurrence and row 31 to 48 is...
11. ## Thread: Help! Excel formula - Pulling from data to another sheet

by Aryatect
Replies
1
Views
112

### Re: Help! Excel formula - Pulling from data to another sheet

Hi, This is 1 option:

Taking more details from https://www.mrexcel.com/forum/excel-questions/1107193-simple-formula-excel.html

12. ## Thread: Average or occurrences help needed

by Aryatect
Replies
7
Views
221

### Re: Average or occurrences help needed

Try below:

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
13. ## Thread: Average or occurrences help needed

by Aryatect
Replies
7
Views
221

### Re: Average or occurrences help needed

Hi, Below should work if you data range header is in A1 & B1 and data starting in A2&B2:

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
14. ## Thread: IDs Included in Another Table

by Aryatect
Replies
3
Views
117

### Re: IDs Included in Another Table

Glad could help and thanks for the feedback.
15. ## Thread: IDs Included in Another Table

by Aryatect
Replies
3
Views
117

### Re: IDs Included in Another Table

Hi, See if this help:

A
B
C
D
E
16. ## Thread: Find Latest value that meets Criteria

by Aryatect
Replies
8
Views
284

### Re: Find Latest value that meets Criteria

Glad we could help and thanks for the feedback !

by Aryatect
Replies
3
Views
101

18. ## Thread: pivot table field list keeps disappearing / fields dont appear in order

by Aryatect
Replies
3
Views
101

### Re: pivot table field list keeps disappearing / fields dont appear in order

Hi, Think of it this way 1 worksheet can have multiple pivot tables which may or may not refer to the same source raw data, if field list would appear if you click anywhere and add any field how...
19. ## Thread: Show 40 hours worked

by Aryatect
Replies
5
Views
163

### Re: Show 40 hours worked

Glad we could help and thanks for the feedback!
20. ## Thread: Find Latest value that meets Criteria

by Aryatect
Replies
8
Views
284

### Re: Find Latest value that meets Criteria

Another option:

=MAXIFS(B5:B10,A5:A10,C1,C5:C10,">"&0)
21. ## Thread: Show 40 hours worked

by Aryatect
Replies
5
Views
163

### Re: Show 40 hours worked

Hi, Welcome to the message board, your formula should check =(J5>=40/24,40/24,J5) as 40 hours are 1.66666 in numeric value. If you are looking for further assistance can you please post some sample...
22. ## Thread: Find Latest value that meets Criteria

by Aryatect
Replies
8
Views
284

### Re: Find Latest value that meets Criteria

Thanks Sam_D_Ben

by Aryatect
Replies
7
Views
129

24. ## Thread: Find Latest value that meets Criteria

by Aryatect
Replies
8
Views
284

### Re: Find Latest value that meets Criteria

Hi, Try Below:

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
25. ## Thread: using dates with index matches

by Aryatect
Replies
7
Views
129

### Re: using dates with index matches

In MATCH, you used C1:C3 which was end of month, I am using B1:B3 which is beginning of month. End of month will move the match back 1 row when match is less than 2nd row in this case hence 1 where...
Results 1 to 25 of 150
Page 1 of 6 1