# Search:

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

Page 1 of 6 1

1. ## Thread: Problem with formula

by RasGhul
Replies
2
Views
154

### 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?
2. ## Thread: Booking Tracker

by RasGhul
Replies
1
Views
120

### 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
113

### 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
153

### 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
202

### 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
79

### 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
155

### 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
124

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

When I used =ROUND(SUM(B1:B4),0) the result was 0.
9. ## Thread: Adding formula to excel table

by RasGhul
Replies
1
Views
90

### 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
111

### 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
235

### 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
235

### 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
153

### 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:...
14. ## Thread: Date Subtraction using business days

by RasGhul
Replies
1
Views
43

### Re: Date Subtraction using business days

=networkdays(b2,a2)
15. ## Thread: saving hyperlinks between Workbooks

by RasGhul
Replies
2
Views
86

### Re: saving hyperlinks between Workbooks

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

You could use hyperlink formula instead so that is dynamically changes with your workbook name. e.g....
16. ## Thread: Select Value from dropdown list and display the range of cells from the worksheet

by RasGhul
Replies
3
Views
140

### 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
140

### 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

### Re: excel hyperlink issue

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
90

### 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
120

### 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
507

### Re: First date within 2 tables

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

by RasGhul
Replies
6
Views
310

### 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
195

### 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
511

### 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
310

### 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