# Search:

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

Page 1 of 6 1

1. ## Thread: Problem with formula

by RasGhul
Replies
2
Views
159

### Re: Problem with formula

Hi

It looks like sumproduct may be more useful here, can you post some sample data so we can look at it?

by RasGhul
Replies
1
Views
123

### Re: Booking Tracker

Can you post some sample data?
3. ## Thread: months from 1 to 12 in columns (in numeric format) not sorting correctly in a pivot

by RasGhul
Replies
2
Views
119

### Re: months from 1 to 12 in columns (in numeric format) not sorting correctly in a pivot

Is yr source data real dates?

highlight your month numbers in the pivot and sort options/manual sort.

you should be able to change the order in the pivot.
4. ## Thread: Sum If a Pivot Table Data Set Based on Date

by RasGhul
Replies
4
Views
162

### Re: Sum If a Pivot Table Data Set Based on Date

If you convert your source data to a table we can use sumifs with table referencing to be dynamic;

e.g =sumifs(table1[AP],table1[Week Ending],"<"&B12)

Right click on your sheet tab for your...
5. ## Thread: Rank using 3 criteria

by RasGhul
Replies
4
Views
209

### Re: Rank using 3 criteria

Try

=SUMPRODUCT((COUNTIF(\$F\$3:\$F\$22,"<"&\$F3)+(COUNTIF(\$I\$3:\$I\$22,">"&\$I3)+(COUNTIFS(\$F\$3:\$F\$22,\$F3,\$M\$3:\$M\$22,">"&\$M3)+1))))
6. ## Thread: Scheduling in Excel

by RasGhul
Replies
1
Views
81

### Re: Scheduling in Excel

I would use the =NETWORKDAYS(startdate,enddate,[Holidays]) function to filter workdays.

There are plenty of decent youtube videos on gantt charts if you look around.
7. ## Thread: Project Workplan Dashboard

by RasGhul
Replies
2
Views
162

### Re: Project Workplan Dashboard

I know its not VBA but maybe this helps.

I used an array on the data prep tab to extract Project Names greater than 0 only. Then pointed the data source for the Projected vs Actual at the data...
8. ## Thread: Issue in sum of positive amount & Negative Amount

by RasGhul
Replies
3
Views
130

### Re: Issue in sum of positive amount & Negative Amount

When I used =ROUND(SUM(B1:B4),0) the result was 0.

by RasGhul
Replies
1
Views
93

### Re: Adding formula to excel table

Make sure the auto format option is working,

Navigate to Options/Proofing/AutoCorrrect Options...(button)/AutoFormat as you Type;

Tick all boxes including "Include new rows and columns in table...
10. ## Thread: Automating pulling data from several sheets into a master sheet

by RasGhul
Replies
1
Views
113

### Re: Automating pulling data from several sheets into a master sheet

Hi Younis,

A formula solution would be difficult to make dynamic and maintain, if VBA is ok you can try this.

I'm not sure if it will handle data with blank rows and make sure to test on a...
11. ## Thread: Transactions Per Hour

by RasGhul
Replies
9
Views
241

### Re: Transactions Per Hour

Muz can you post your formula for sa7toot as well pls mate?
12. ## Thread: Transactions Per Hour

by RasGhul
Replies
9
Views
241

### Re: Transactions Per Hour

Can you post some sample data, so we can check it out for you.
13. ## Thread: Sum If a Pivot Table Data Set Based on Date

by RasGhul
Replies
4
Views
162

### Re: Sum If a Pivot Table Data Set Based on Date

It might be easier to SUMIFS on your data?

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...

by RasGhul
Replies
1
Views
46

### Re: Date Subtraction using business days

=networkdays(b2,a2)

by RasGhul
Replies
2
Views
88

### Re: saving hyperlinks between Workbooks

When you use standard hyperlinks it hard codes the current workbook/sheet referencing with it.

16. ## Thread: Select Value from dropdown list and display the range of cells from the worksheet

by RasGhul
Replies
3
Views
142

### Re: Select Value from dropdown list and display the range of cells from the worksheet

You're welcome.
17. ## Thread: Select Value from dropdown list and display the range of cells from the worksheet

by RasGhul
Replies
3
Views
142

### Re: Select Value from dropdown list and display the range of cells from the worksheet

Is this what you need?

If I understand your goal correctly you can do this with a hyperlink formula, setup in this fashion you can enter target column & rows, the dv dropdown list of column G is...

by RasGhul
Replies
1
Views
105

You could use a dynamic hyperlink formula based on your index & File names;

Can you post some sample data?
19. ## Thread: Creating a map chart with England areas only

by RasGhul
Replies
1
Views
93

### Re: Creating a map chart with England areas only

Hi NJ,

I've used this technique before as a good work around for map charts.

20. ## Thread: Combine data into limited quantities efficiently

by RasGhul
Replies
1
Views
121

### Re: Combine data into limited quantities efficiently

Can you post some sample data?
21. ## Thread: First date within 2 tables

by RasGhul
Replies
1
Views
514

### Re: First date within 2 tables

Can you post some sample data?
22. ## Thread: Manual Sales Report Help

by RasGhul
Replies
6
Views
312

### Re: Manual Sales Report Help

I've freed up the formulas on the convert tab, and I also needed to have my PC on US Date Region, date format mm/dd/yy. When I reverted my PC back to my region & format the date formulas result in an...
23. ## Thread: IF AND OR Formula

by RasGhul
Replies
4
Views
198

### Re: IF AND OR Formula

Maybe try;

=IF(AND(OR(E2="VIC",E2="NSW",E2="QLD"),A2>100000),">100000",IF(AND(OR(E2="NSW",E2="SA"),A2>160000),">160000"))
24. ## Thread: INDEX/MATCH & SUMIF (with one and/or two comma separated reference numbers)

by RasGhul
Replies
19
Views
516

### Re: INDEX/MATCH & SUMIF (with one and/or two comma separated reference numbers)

Can you post some sample data?
25. ## Thread: Manual Sales Report Help

by RasGhul
Replies
6
Views
312

### Re: Manual Sales Report Help

Hi Chris,

We're now returning Lite Server ID Numbers and ignoring rows that have blanks in the payment types/receipts overview.

I would recommend using the Convert & Output tabs to extract the...
Results 1 to 25 of 150
Page 1 of 6 1