def

Hello, I need a formula to count values from one column(Vendor) by the category of another. From there need to sum the value if the count is greater/equal to 2. EG.) Category......... Vendor......... Count(formula)........ Value.......... Sum(formula) Blue...

Hi folks, I need a formula column to aggregate the codes billed per customer visit (solution would look like E2:E10 below). Then later I can include the results in a PivotTable to see the combo frequency of codes billed at this store. There is a large list of customer transactions. Each row...

Sheet 1 <tbody> ABC 40 DEF 25 GHI 35 XYZ 20 </tbody> Sheet 2 <tbody> ABC 45 DEF 20 GHI 10 PQR 18 XYZ 40 </tbody> I want changes in value in 3rd sheet based on name criteria match of both sheet and additional name and value of sheet 2. Could you please solve my issue.

I have a table that I determine the rank # with this formula:=SUMPRODUCT((ABS(AF7-0)>ABS(AF$5:AF$19-0))+0)+1 To get this: <colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col...

Hey Excel Gurus, I have a large data with multiple worksheets. Please my requirement this time is for a vba code that performs trimming on the existing data present in all worksheets of my workbook. For example if text is (without the quotation marks): " abc def " the code runs and check for...

Hi, I have spread sheet and wants it to be in new order. Existing sheet Records <tbody> Roll No Name Ph1 ph2 ph3 ph4 ph5 ph6 1 abc 0300 677 748 2 def 767 87 3 hij 88 88 88 88 88 88 </tbody> New look i wants as <tbody> Roll No Name Ph 1 abc 0300 1 abc 677 1 abc 748 2...

Hello, I am attempting to do the following and would appreciate any help: I have a spreadsheet that looks like the following <tbody> ABC ABC-001 DEF DEF-001 ABC ABC-002 ABC ABC-003 DEF DEF-002 </tbody> I manually enter in the information in the first column. In the second column, I...

<tbody> ABC - DEF - GHI - JKL - MNO ABC DEF GHI JKL MNO ABC - DEF - GHI - JKL - MNO ABC DEF </tbody> Using SPLIT with a "-" delimiter gives the first output above - is there a way to limit the command so it splits ONLY the first two parts? Thanks for your help!

<tbody> YEAR YRFILECNT YEARRANK CLIENT BR STA STACNT 19 342 1 ABC 32 CHIO 207 19 34 1 ABC 32 CHIA 134 19 342 1 ABC 42 LAX 1 19 267 2 DEF 52 SFO 250 19 267 2 DEF 52 SFA 16 19 267 2 DEF 32 CHIA 1 19 223 3 GHI 32 CHIA 222 19...

i created a pivot table as below. in my table i want to running serial number of every row as sequence wise. Date: 00-00-0000 (report filter) ROW NAME LCB CB VCB LMDF 1 ABC 10 05 15 20 2 DEF 09 12 21 10 3 GHI 15...

Hi, I have a problem to solve. I have a data set of 7000 transactions and I need to calculate the amount for each transaction as per below formula. Please note that calculation will be done basis of account number. <tbody> Account Number Value Percentage Amount ABC 1000 0.1 =(B2)*C2-0...

I have a list. The first column is the Parent Part Number, the second is the individual parts that go into each parent. I am trying to see if the individual part is used in more than one parent. What I need is to come up with a percentage. its kind of hard to explain. Hope this helps. The...

Hi, i need help friends for writing VBA code for copying data . For example i have data in A and B columns. when I click on button Data must get Copy as Jan ABC,JAN DEF continue till B end, then a2 b1,a2 b2 etc. <colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody> A...

Hi I need help on how to extract unique name from the excel cell and then sum up the total score for each name. I have excel sheet where the name for all participates has entered in one cell as example below Name Score ABC;#DEF;#HIJ;# 5 ABC;#XYZ;#HIJ;# 2 MNO;#DEF;#HIJ;# 3...

Because the heading is so clear! I have the following data: <tbody> A B C D E F H I J K UPN Name Year SEN Care FSM Subject Type Class Points 123 abc 7 S Y Y Geography Homework 7L4/Gg 1 456 def 7 Technology Homework 7L4/Te 1 678 ghi 8 S Y Science Disruption to Learning 8a/Sc3 2...

I have a portfolio with hundred of stocks, but for simplicity, let's say I have three stocks, with their respective PERs and market caps: <tbody> PER Market Cap ABC 15 150 DEF 10 101 XYZ 12 80 Market-cap-weighted average 12.99x Formula ? </tbody> I would like to take a...

Hello, I have 100 GL accounts and each GL has the same list of projects, as example- six projects. I need to copy each GL account down for each project. Can you help to write a Macro to automate this process? <colgroup><col style="mso-width-source:userset;mso-width-alt:3876;width:80pt"...

Hello, I search the forum for something familiar but I cannot find any. Please help me out. Example column H, row 3-10 have data which includes blank. What I want to do is whatever data entered in column I get extracted to column T without the blank. Copy and paste are tedious for hundreds of...

I have the following text wrapped with a line break in a single cell: ABC 1232 DEF 456 GHI 78910 I want a lookup formula to just return DEF 456? Can someone help.

Hi Excel Champs, Please help me getting this calculated I have data like this <tbody> Date Emp Code Emp Name Productivity AHT 15-02-2018 726462 ABC 254 10 Min 15-02-2018 734840 DEF 123 12 Min 15-02-2018 746569 GHI 656 3 Min 15-02-2018 726462 ABC 153 20 Min 15-02-2018 734840 DEF 345...