# Search:

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

Page 1 of 6 1

1. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

Cheers i will test it now
2. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

So do you mean like this
...
3. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

HI Steve
Please check you Inbox when you get an oppurtunity

Thank You
4. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

HI Steve
I have done as you suggested, plus can i thank you for your help
Is there a way a marking it as solved?
5. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

Steve can you check sheet to see if i have filled it in as you suggested correctly ?

Working correctly from what i can see
6. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

Yes i know what it means but why you adding that onto the fact table?

<tbody>
Category Price FVF needs to be on the research tab not the fact table

</tbody>
7. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

Hi Steve
The table you show will not work the last 3 column headers stop this being a fact lookup table
I have 1000's of item under these headings all at different prices.
8. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

HI Steve

I have done a new table which i have named but the formula does not refer to it?
9. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

Home Furniture DIY = 10% first 250 then 6%
Home Furniture DIY>Bath = 9% first 250 then 6% but capped at £40
Home Furniture DIY>Furniture = 9% first 250 then 6% but capped at £40
Home Furniture...
10. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### Re: How can I determine multi-level value fees from a table of fees for a given value?

HI Steve

Sorry i do not think i have explained it enough the current formula works but it is changing in July.
If you look at the newallfees you should see a image showing the new calculations on...
11. ## Thread: How can I determine multi-level value fees from a table of fees for a given value?

by daleholden
Replies
21
Views
485

### How can I determine multi-level value fees from a table of fees for a given value?

HI Guys/Girls

I need to change my formulas and/or lookup table structure to calculate a new fee structure bring implemented in July by eBay.
I need to determine multi-level value fees from a...
12. ## Thread: Power Query Merge Issue missing Data

by daleholden
Replies
3
Views
789

### Re: Power Query Merge Issue missing Data

I fixed it with
I had a filter set in PQ on one of the queries to filter out 0 Qty but when trouble shooting it also had several other low values unchecked.
I re did the filter and now it works...
13. ## Thread: Power Query Merge Issue missing Data

by daleholden
Replies
3
Views
789

Self Solved
14. ## Thread: Power Query Merge Issue missing Data

by daleholden
Replies
3
Views
789

### Power Query Merge Issue missing Data

Hi Guys
I need some help with a PQ Merge issue i have to tables that i merge with the simple idea via a SKU it collects Categories from another table. All SKU's are present and the Cats are also...
15. ## Thread: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

by daleholden
Replies
18
Views
1,915

### Re: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

Hi Jerry

You had any luck with this file?
16. ## Thread: Index Match or IF Nested Formulas need most efficient Way Formula

by daleholden
Replies
10
Views
382

### Re: Index Match or IF Nested Formulas need most efficient Way Formula

HI

I think I am struggling to explain it correctly :)

Store 1 feeds 5 other cells that does a different lookup and calculations based on Store 1.

SO this is a current formula i am using...
17. ## Thread: Index Match or IF Nested Formulas need most efficient Way Formula

by daleholden
Replies
10
Views
382

### Re: Index Match or IF Nested Formulas need most efficient Way Formula

HI

I think i am struggling to explain it correctly :)

Store 1 feeds 5 other cells that does a different lookup and calculations based on Store 1.

SO this is a current formula i am using...
18. ## Thread: Index Match or IF Nested Formulas need most efficient Way Formula

by daleholden
Replies
10
Views
382

### Re: Index Match or IF Nested Formulas need most efficient Way Formula

HI

The drop down has to stop the same if possible so when i select Store 1 in my main data sheet Store 1 has 6 different columns which start with Store 1 but appended with FVF , VAT , VAT Excl as...
19. ## Thread: Index Match or IF Nested Formulas need most efficient Way Formula

by daleholden
Replies
10
Views
382

### Re: Index Match or IF Nested Formulas need most efficient Way Formula

HI Alan

That works great but i need to know is it possible to achieve this if the title headers do not match the dropdown?
I know it is a stupid question but Store1 has many headers Eg Store1...
20. ## Thread: Index Match or IF Nested Formulas need most efficient Way Formula

by daleholden
Replies
10
Views
382

### Index Match or IF Nested Formulas need most efficient Way Formula

Please, see attached worksheet to explain what I am looking to achieve.

Also, do the headers in Data row have to match the dropdown box?
21. ## Thread: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

by daleholden
Replies
18
Views
1,915

### Re: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

HI Jerry

Please, can you view the file I have added a new tab with a graphic explanation?

Let me know if you need further explanation or clarification.

I guess the eBay FVF CATs table may...
22. ## Thread: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

by daleholden
Replies
18
Views
1,915

### Re: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

Hi
Sorry I thought my explanation who be clear enough.
I will put a sheet together showing what I am trying to achieve tomorrow
23. ## Thread: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

by daleholden
Replies
18
Views
1,915

### Re: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

HI

I will try to explain as best I can in the eBayCatCodes worksheet we have all the codes eBay uses.
So for a simple example Antiques has 301 different codes but it will always be charged at 9%...
24. ## Thread: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

by daleholden
Replies
18
Views
1,915

### Re: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

HI
Sorry, I have no idea what you have done! It is nothing like I am trying to achieve.

You have created a connection to the Category leaf name this is of no use really.

We need to convert...
25. ## Thread: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

by daleholden
Replies
18
Views
1,915

### Re: March Conundrum Power Query Problem and the Correct Path to Take !!!!!

HI
My initial question was asking the best way

"I need to merge or append or some other kewl way to lookup the codes to see where they belong exactly. But I need them to show the correct ID...
Results 1 to 25 of 150
Page 1 of 6 1