gold

  1. F

    VBA Vlookup help

    Im looking for a VBA code that works like Vlookup. Lookup data= A:B (D1) is a dropdown list of A:A (E1) is a manual input of a number. When the Macro is ran, I want it to search for (D1) in column A:A and increase the amount in the corresponding B:B column by the amount in (E1). <tbody> A B C...
  2. S

    Get Count of Unique Items Within A Designated Area

    So the easiest way to explain what I am trying to do is with an example. See the sample Data below: <tbody> <tbody> Investment </tbody> <tbody> Current/Prior </tbody> <tbody> Routine/NonRoutine </tbody> <tbody> AA </tbody> <tbody> FHLMC GOLD PL V84191 </tbody>...
  3. A

    Looking for and old coding friend - Ira Gold

    Anybody know if Ira Gold still is active in this forum? I think I remember the name was ingold? Hope somebody can help me.
  4. M

    find and list top 10 items in a table showing their row and column labels?

    I have a table which summarises the number of sales of tshirts of each colour combination (its actually much bigger than this) I'd like to show a list of the top 10 most popular colour combos so somehow i have to find the highest 10 values from these cells and display a list of them, in order...
  5. L

    Macro - copy and insert rows of data based on value in one column

    I have read many posts similar to this but can't get my vba code to work. Please help. Sample data: <tbody> A1 A2 A3 A4 A5 A6A7 </tbody> <colgroup><col><col><col><col><col><col><col></colgroup><tbody> 21609 Gold $10 Person1 1 $10 Raffle1 21609 Gold $10 Person2 9 $90 Raffle1 21609...
  6. M

    Gross profit forum

    I need a formula to work out gross profit. I am a jeweller selling rings. A Ring Price. B VAT 20%. C Assay Fee (Always 17.50). D. Gold Price. E Total Cost F Gross Profit I think it should be B + C + D = E. F - E = GROSS PROFIT (I THINK)
  7. M

    Multiple awards separate into different columns

    Thank you in advance. I have a spreadsheet with participants winning multiple awards. I want the awards in separate columns tiled Awards 1 Award 2 Award 3.... I have this... <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Name Award Jane Gold...
  8. A

    Trying to separate words from text

    Maybe someone can help me figure this out and hopefully it is a fun one for you guys to figure out. :) I am trying to separate text from a long list of products. In the middle of the name is either the word "silver" or "gold" and then there is a jewelry type. The problem is that some of the...
  9. R

    VBA Code - More than one Depended Combobox.

    Hi Friends, Case : Below table shows some product details, where in under column A we have only 2 product i.e. Product A & Product B. Column B represent product Group & Last column C represent Grade of (Product and its group). Excel Sheet 1. <tbody> A B C 1 Product Group Grade 2...
  10. U

    Delete specific strings on a column with a formula that includes all the strings that i want deleted

    I'm trying to delete ... Pantalla 5.5" Pantalla 5.0" Pantalla 5.2" Pantalla 5" Pantalla 4.0" Pantalla 2.0" Pantalla 4.5" Pantalla 4.7" from the cellphones names so that they appear as they should ... Acer Liquid Jade Primo 32GB <colgroup><col></colgroup><tbody> This is the the column...
  11. M

    Excel Formula help (if/or)

    Hi Team, I am looking for a formula in B3, Such a that if I found a Cell value (Gold or Silver) in Cell A3, then I want the answer Best in Column (b3). Else dont change any value in B3. Then i want to drag the formula till last cell value. Through Filtering I can get the result, I am looking...
  12. A

    Comparing two sheets values and return the header

    Hi All, Good Afternoon, I need to compare Sheet 1 <colgroup><col></colgroup><tbody> SLA 111 221 333 with Sheet 2 below table <colgroup><col><col><col></colgroup><tbody> Gold Silver Bronze 311 211 111 312 212 112 313 213 113 321 221 121 </tbody> </tbody> And return value...
  13. D

    Showing a word based on results

    I feel a bit blonde posting this. But I need an if statement and can't quite get it right. I want it to calculate a percentage then show a word based on the result. So there will be 4 words. If a2 is less than 90% of a1 then the word will show "Bronze" if a2 is 90-90% of a1 then the word will...
  14. L

    Returning a different value depending in which column a match is found

    I have a list of customers who have downloaded a product in column I of a worksheet. We categorise existing customers as 'Gold', 'Silver' or 'Bronze' . In a separate worksheet 'Customer Cats', I have 3 lists of these customers - one 'Gold' column, one 'Silver' and one 'Bronze' column - columns...
  15. D

    Defining Current and Next Comex Futures Contract

    Hi, I don't know how to code but I want to create code where as it check with today's date and define current contact and next contact. All the time I have to change current contract and next contract manually I want computer update it automatically. below is table for gold and silver...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top