VBA - Macro to Output Data into Tab Based on Criteria

lpw0806

New Member
Joined
Jun 14, 2018
Messages
38
Hi -

Thank you in advance for help on this!

I am trying to create a macro (or maybe multiple?) that looks at a a few fields in a "Raw Data" tab and exports results into a tab called "Opportunities". I have 4 categories listed in a column ("Lifestyle", "Multi", "Tech", "Auto" ). I am trying to create 4 separate buttons in the Opportunities tab for each that follow the following rules:



  • If Sales POD (Column S) = "Lifestyle", "Multi", "Tech", "Auto"
  • If Probability (%) (Column K) >=75
  • Then output the results in the "Opportunities" tab (cant figure out how to post a screen shot but I'd want it to look like the below)
  • Then autosize columns
  • Then format columns C-E to be currency

Data to output into Opportunities

[TABLE="width: 445"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Opportunity Name[/TD]
[TD]Opportunity Owner[/TD]
[TD]New[/TD]
[TD]Renewal[/TD]
[TD]Carryover[/TD]
[/TR]
[TR]
[TD]Opportunity 123[/TD]
[TD]Bob Smith[/TD]
[TD][/TD]
[TD]$109,223[/TD]
[TD]$40,774[/TD]
[/TR]
[TR]
[TD]Opportunity 128[/TD]
[TD]Bob Smith[/TD]
[TD]$31,060[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


- Things to keep in mind:



  • I want the "Opportunities" tab to clear / refresh every time to allow for new data to be put in
  • I don't want to output all of the columns in the Raw Data tab in the Opportunities tab. Only the few listed above
  • I want to pull data based on if I pick "Lifestyle", "Multi", "Tech" or "Auto" (why I am thinking multiple buttons?)
  • Column M (R Type) has "New", "Renewal" and "Carryover" relate to "CM Prod" (Column Q)
    • So - in the Opportunities output the $ amount in column Q should be appropriately distributed based on the Opportunity Name (Column C)
    • EX - There could be an Opportunity with the same name (see first two rows) but has $ amount in two different categories (in this example there is $ in Renewal and Carryover)



[TABLE="width: 2107"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Opportunity Owner[/TD]
[TD]Account Name[/TD]
[TD]Opportunity Name[/TD]
[TD]Client Category[/TD]
[TD]2018 Digital Region[/TD]
[TD] 2018 Region[/TD]
[TD]Venue[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Days at Prob[/TD]
[TD]Probability (%)[/TD]
[TD]Product Name[/TD]
[TD]R Type[/TD]
[TD]S Inventory[/TD]
[TD]S Prod[/TD]
[TD]Expen S[/TD]
[TD]CM PROD[/TD]
[TD]Days Bucket[/TD]
[TD]Sales POD[/TD]
[TD]S or D[/TD]
[TD]Account POD[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 123[/TD]
[TD]Opportunity 123[/TD]
[TD]Food[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 123[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]55[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$111,501[/TD]
[TD]$45,068[/TD]
[TD]$109,223[/TD]
[TD]40+[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 123b[/TD]
[TD]Opportunity 123[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 124[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]249[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$3,149[/TD]
[TD]$2,146[/TD]
[TD]$40,774[/TD]
[TD]40+[/TD]
[TD]Enterprise[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 125[/TD]
[TD]Opportunity 125[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 125[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$36,876[/TD]
[TD]$92,037[/TD]
[TD]$45,768[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 126[/TD]
[TD]Opportunity 126[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 126[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]217[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$36,338[/TD]
[TD]$44,417[/TD]
[TD]$121,225[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 127[/TD]
[TD]Opportunity 127[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 127[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$99,261[/TD]
[TD]$83,738[/TD]
[TD]$21,815[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 128[/TD]
[TD]Opportunity 128[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 128[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]61[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]New[/TD]
[TD]XXX[/TD]
[TD]$112,986[/TD]
[TD]$5,710[/TD]
[TD]$31,060[/TD]
[TD]40+[/TD]
[TD]Tech[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 129[/TD]
[TD]Opportunity 129[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 129[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$33,692[/TD]
[TD]$97,260[/TD]
[TD]$52,841[/TD]
[TD]0 - 5[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 130[/TD]
[TD]Opportunity 130[/TD]
[TD]Travel[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 130[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$103,634[/TD]
[TD]$29,028[/TD]
[TD]$58,450[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 131[/TD]
[TD]Opportunity 131[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 131[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$114,605[/TD]
[TD]$81,118[/TD]
[TD]$88,640[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 132[/TD]
[TD]Opportunity 132[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 132[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$93,009[/TD]
[TD]$103,432[/TD]
[TD]$77,888[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 133[/TD]
[TD]Opportunity 133[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 133[/TD]
[TD]Atlanta[/TD]
[TD]GA[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$101,425[/TD]
[TD]$95,077[/TD]
[TD]$56,486[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 134[/TD]
[TD]Opportunity 134[/TD]
[TD]Telecommunications[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 134[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]330[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$124,886[/TD]
[TD]$6,294[/TD]
[TD]$60,924[/TD]
[TD]40+[/TD]
[TD]C&T[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 135[/TD]
[TD]Opportunity 135[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 135[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$107,249[/TD]
[TD]$120,698[/TD]
[TD]$26,576[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 136[/TD]
[TD]Opportunity 136[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 136[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$43,519[/TD]
[TD]$111,415[/TD]
[TD]$855[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 137[/TD]
[TD]Opportunity 137[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 137[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$21,369[/TD]
[TD]$73,453[/TD]
[TD]$64,164[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 138[/TD]
[TD]Opportunity 138[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 138[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$7,859[/TD]
[TD]$83,157[/TD]
[TD]$57,123[/TD]
[TD]0 - 5[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 139[/TD]
[TD]Opportunity 139[/TD]
[TD]Travel[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 139[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Sponsorship Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$17,357[/TD]
[TD]$101,002[/TD]
[TD]$82,221[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 140[/TD]
[TD]Opportunity 140[/TD]
[TD]Food[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 140[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]55[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$12,492[/TD]
[TD]$96,449[/TD]
[TD]$26,979[/TD]
[TD]40+[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 141[/TD]
[TD]Opportunity 141[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 141[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]249[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$10,112[/TD]
[TD]$76,557[/TD]
[TD]$92,298[/TD]
[TD]40+[/TD]
[TD]Enterprise[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 142[/TD]
[TD]Opportunity 142[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 142[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$62,251[/TD]
[TD]$111,068[/TD]
[TD]$24,511[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 143[/TD]
[TD]Opportunity 143[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 143[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$54,520[/TD]
[TD]$102,905[/TD]
[TD]$31,973[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 144[/TD]
[TD]Opportunity 144[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 144[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$86,803[/TD]
[TD]$8,869[/TD]
[TD]$118,660[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 145[/TD]
[TD]Opportunity 145[/TD]
[TD]Technology[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 145[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]61[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]New[/TD]
[TD]XXX[/TD]
[TD]$118,992[/TD]
[TD]$4,577[/TD]
[TD]$53,738[/TD]
[TD]40+[/TD]
[TD]Tech[/TD]
[TD]S[/TD]
[TD]Tech[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 146[/TD]
[TD]Opportunity 146[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 146[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$58,141[/TD]
[TD]$75,398[/TD]
[TD]$70,245[/TD]
[TD]0 - 5[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 147[/TD]
[TD]Opportunity 147[/TD]
[TD]Automotive[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 147[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]81[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$18,589[/TD]
[TD]$66,556[/TD]
[TD]$69,673[/TD]
[TD]40+[/TD]
[TD]Multi[/TD]
[TD]S[/TD]
[TD]Auto[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 148[/TD]
[TD]Opportunity 148[/TD]
[TD]Travel[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 148[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$119,560[/TD]
[TD]$27,868[/TD]
[TD]$8,312[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 149[/TD]
[TD]Opportunity 149[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 149[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$50,713[/TD]
[TD]$78,221[/TD]
[TD]$11,109[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 150[/TD]
[TD]Opportunity 150[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 150[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$89,270[/TD]
[TD]$33,972[/TD]
[TD]$108,332[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 151[/TD]
[TD]Opportunity 151[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 1: East[/TD]
[TD]Venue 151[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]85[/TD]
[TD]85[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$51,667[/TD]
[TD]$55,737[/TD]
[TD]$70,271[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 152[/TD]
[TD]Opportunity 152[/TD]
[TD]Alcohol[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 152[/TD]
[TD]San Francisco[/TD]
[TD]CA[/TD]
[TD]144[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Renewal[/TD]
[TD]XXX[/TD]
[TD]$26,202[/TD]
[TD]$79,538[/TD]
[TD]$120,738[/TD]
[TD]40+[/TD]
[TD]Lifestyle[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 153[/TD]
[TD]Opportunity 153[/TD]
[TD]Energy Drink[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 153[/TD]
[TD]San Francisco[/TD]
[TD]CA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$99,693[/TD]
[TD]$56,440[/TD]
[TD]$40,579[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Lifestyle[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]Account 154[/TD]
[TD]Opportunity 154[/TD]
[TD]Financial Services[/TD]
[TD]Unknown[/TD]
[TD]Region 2: West[/TD]
[TD]Venue 154[/TD]
[TD]San Francisco[/TD]
[TD]CA[/TD]
[TD]230[/TD]
[TD]100[/TD]
[TD]Digital Products[/TD]
[TD]Carryover[/TD]
[TD]XXX[/TD]
[TD]$17,758[/TD]
[TD]$37,946[/TD]
[TD]$43,107[/TD]
[TD]40+[/TD]
[TD]N/A[/TD]
[TD]S[/TD]
[TD]Multi[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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