gold

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

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

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

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

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

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)

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

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

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

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

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

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

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

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

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