Distribution of Excel via formula

L

love88king

New Member
Joined
Aug 26, 2014
Messages
5
can any one help me please with my excel sheet below, i want to distribute the original table (Disc) to be as Distribution on the invoices as :


OriginalDistribution
DateNameInvNoDiscDateNameInvNoDisc
01/01/2014DAM1001/01/2014DAM10
01/01/2014DAM2001/01/2014DAM20
01/01/2014DAM3001/01/2014DAM30
01/01/2014DAM9001/01/2014DAM90
01/01/2014HO11001/01/2014HO15
01/01/2014HO11001/01/2014HO15
01/01/2014HO249501/01/2014HO2247.5
01/01/2014HO249501/01/2014HO2247.5
01/01/2014HO3001/01/2014HO30
01/01/2014HO3001/01/2014HO30
01/01/2014HO4801/01/2014HO48
01/01/2014HO5001/01/2014HO50
01/01/2014HO6001/01/2014HO60
01/01/2014HO79901/01/2014HO749.5
01/01/2014HO79901/01/2014HO749.5
01/01/2014HO844301/01/2014HO8443
01/01/2014HO9001/01/2014HO90
01/01/2014JED0314001/01/2014JED03140
01/01/2014JED031578001/01/2014JED0315390
01/01/2014JED031578001/01/2014JED0315390
01/01/2014JED0316001/01/2014JED03160
01/01/2014JED045001/01/2014JED0450
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15
01/01/2014JED046815301/01/2014JED046 627.15

<tbody>
</tbody>
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Sort by date Sort by votes
assuming date is column a, name column b etc, you can add a column after column d (disc) and enter this formula & paste down
=D2/COUNTIFS(B:B,H2,C:C,I2)
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Userform exit while code is running
Replies
1
Views
427
Domenic
D
D
  • Question
Excel OFFSET name formula showing zeros
Replies
5
Views
201
db74
D
B
  • Solved
How post define formulas only if cells have a value
Replies
3
Views
242
Blockhead15
B
M
  • Question
Worked time between multiple dates
Replies
1
Views
388
SanjayGMusafir
SanjayGMusafir
S
  • Solved
Re-Configure, duplicate and restructure data set into a new format. Seems complex but Im sure there is a way.
2
Replies
18
Views
490
kevin9999
K

Forum statistics

Threads
1,202,987
Messages
6,052,936
Members
444,616
Latest member
novit19089

Share this page

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