# Search:

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

Page 1 of 2 1

1. ## Thread: COUNTIF with Multiple Criterias and Range

by jayjavina
Replies
9
Views
484

### Re: COUNTIF with Multiple Criterias and Range

That's alright Andrew. I'll use that as an alternative. Thank you.

Thanks Par, I tried your technique and it worked. I never thought that you can use the same criteria twice for this type of...
2. ## Thread: COUNTIF with Multiple Criterias and Range

by jayjavina
Replies
9
Views
484

### Re: COUNTIF with Multiple Criterias and Range

Thanks for the reply Andrew. But how do i write it with the percentage inside the formula without using the LEFT/RIGHT function?

The actual title for the range is - Percentage of players who...
3. ## Thread: COUNTIF with Multiple Criterias and Range

by jayjavina
Replies
9
Views
484

### COUNTIF with Multiple Criterias and Range

Hi Gurus,

May I please ask for some assistance on how will i be able to get the percentage of each team with members receiving a different set of scores.

I tried this formula and it doesnt seem...
4. ## Thread: SUBTOTAL with Multiple Conditions

by jayjavina
Replies
2
Views
461

### SUBTOTAL with Multiple Conditions

Hi gurus!

I would like to ask for your expertise on how I can resolve this issue of mine.
I would like to get the average of all the values under the R-E-D category on different locations.
I...
5. ## Thread: Extracting records that match different criteria for multiple reports in different sheets

by jayjavina
Replies
3
Views
214

### Re: Extracting records that match different criteria for multiple reports in different sheets

Let me try to work it out at my end.

SAV means savings. its actually the Salary, allowance and tax tables.
Savings is based on the ACTUAL value. thats why I...
6. ## Thread: Extracting records that match different criteria for multiple reports in different sheets

by jayjavina
Replies
3
Views
214

### Extracting records that match different criteria for multiple reports in different sheets

Hi Excel Gurus,

I would like to ask for some assistance on how I can better manage this monthly report. Below are the conditions and the output will be shown in a different sheet in the below...
7. ## Thread: Data Validation Query With Calculation

by jayjavina
Replies
1
Views
128

### Re: Data Validation Query With Calculation

Any help out there?
8. ## Thread: Data Validation Query With Calculation

by jayjavina
Replies
1
Views
128

### Data Validation Query With Calculation

Hi excel guru's,

I would like to seek your help in creating a dynamic table for the total sale.
Below are a list of store supplies with different categories and vendors.

Here is what I want to...

by jayjavina
Replies
2
Views
19,591

Hi,

i would like to ask if "Easy-XL"is available in other format other than .exe or .msi?

it is because I wont be able to install it at work. we are not allowed to install any application(.exe...

by jayjavina
Replies
8
Views
517

### Re: Date/Time/Public Holidays

Thanks much!

Am still trying to fully understand the whole logic of formula...

but really appreciate the help.
Now am trying to calculate how many hours it took them to finish the job but i...

by jayjavina
Replies
8
Views
517

### Re: Date/Time/Public Holidays

It works just fine! Many thanks! :)

Is there a way for the target date to show the time too? Its not much but good to have in one column rather than two.

this is what i did, a very minor...

by jayjavina
Replies
8
Views
517

### Re: Date/Time/Public Holidays

Hi! Thanks for taking the time to read my post.

Whatever complaint received after 1600, it will be serviced the next day from 0800 till end of day meaning till 2400, but its only till end of...

by jayjavina
Replies
8
Views
517

### Date/Time/Public Holidays

Hi,<o:p></o:p>
<o:p></o:p>
I have quite a challenging procedure that needs the excel MVPs expertise.<o:p></o:p>
I have been asked to calculate if we are meeting the required SLA in processing our...
14. ## Thread: How to count similar values in pivot as 1

by jayjavina
Replies
5
Views
604

### Re: How to count similar values in pivot as 1

Thanks Fazza. AM not that familiar with SQL but let try to study it first.

Appreciate it
15. ## Thread: How to count "BLANK" cells in a pivot table

by jayjavina
Replies
10
Views
43,389

### Re: How to count "BLANK" cells in a pivot table

Thanks for the idea :beerchug:!

I just inserted another column in the data table and hid it so that it wont show to the users.

I hope it fail me in the pivot table.
16. ## Thread: How to count "BLANK" cells in a pivot table

by jayjavina
Replies
10
Views
43,389

### Re: How to count "BLANK" cells in a pivot table

<title>Excel Jeanie HTML</title>Here is a sample A1:B13 is the data and from column D to H is the pivot table. How will i show the total number of blank cells in "(blank)" column in the pivot...
17. ## Thread: How to count "BLANK" cells in a pivot table

by jayjavina
Replies
10
Views
43,389

### Re: How to count "BLANK" cells in a pivot table

Thanks for the help but, what i want is within the pivot table. Pivot table will be the one to count the blanks. I dont want to have a separate column to write down a formula to count the blanks.
...
18. ## Thread: How to count "BLANK" cells in a pivot table

by jayjavina
Replies
10
Views
43,389

### Re: How to count "BLANK" cells in a pivot table

Yes, i only want to count those in the data ranges. I dont have other issues its just i want the pivot table to count the blank cells.
19. ## Thread: How to count "BLANK" cells in a pivot table

by jayjavina
Replies
10
Views
43,389

### Re: How to count "BLANK" cells in a pivot table

Thanks Aladin. But how do you count blank cells in a pivot table.
20. ## Thread: How to count "BLANK" cells in a pivot table

by jayjavina
Replies
10
Views
43,389

### How to count "BLANK" cells in a pivot table

Hi,

Is there a way to count blank cells in a pivot table?

How about a formula to count blank cells too?

Thanks much and Merry Christmas! :biggrin:
21. ## Thread: Excel 2007 security on sheets for shared workbooks

by jayjavina
Replies
0
Views
251

### Excel 2007 security on sheets for shared workbooks

Hi,

is it possible to set some security in a specific sheet where in only a specific user can open since the workbook shared with different users?

Ex. SHEET1 can only be opened by Mr.B and...
22. ## Thread: Sheet names and VBA

by jayjavina
Replies
5
Views
300

### Re: Sheet names and VBA

Cool, thanks again!
23. ## Thread: Sheet names and VBA

by jayjavina
Replies
5
Views
300

### Re: Sheet names and VBA

Thanks bro!
By the way, what is the 1,255 for?

One more thing, can we limit the number of user is a specific sheet? What am saying is can we set some security in a specific sheet or making a...
24. ## Thread: Sheet names and VBA

by jayjavina
Replies
5
Views
300

### Sheet names and VBA

Is it possible for the sheet name to appear in a specified cell without using VBA codes?

Let's say if i rename "SHEET1" to "MYNAME", "MYNAME" will appear in cell A1.

Thanks!!!:biggrin:
25. ## Thread: Help on IF function

by jayjavina
Replies
8
Views
304

### Re: Help on IF function

Got it Dom! Many Thanks!!!

crimson_b1ade, am trying it as well thanks too bro!

Appreciate it!
Results 1 to 25 of 30
Page 1 of 2 1