matrix formula

I have 3 markets that account for all sales for current year and last year. I am able to use the % of row calculated field to see the share of each market for each product level, but I am looking to calculate the share change for each market vs. last year for each product level. So for Dept 2 it...

Hi guys. I'm a bit new in VBA coding, but have worked with Excel a lot. I have this Claim sheet I am working on. And I need the Claim Importance to show (Low, Medium, High) on multiple variables. My formula right now is...

Hello! I'm trying to create a "transaction matrix" of sorts for expediting the AMEX statement at the end of the month. I've got columns designated for my full employee's names, with rows going to shortened purchase names. For instance, "Uber Xasdqb239871-0-X" was shortened to just "Uber". I...

Hi all, I have a list of data (songs), numbered in column A starting at cell A3 with 1. In column E I have the BPM (Beats Per Minute) starting at cell E3. I want to search for all songs with matching BPM within Excel, so the output will be a list of the numbers of the songs with matching BPM...

Hey all I've got an equation that is working but has an issue. Objective: to find the amount of time it takes to switch from one activity to the next. In order to say the switch is complete 5 activities must be complete in a certain amount of time. Attempted Solution: I used a...

Hello, this is my first thread but I have been reading and learning since months if not years. Now I'm stuck with this problem and I can't find a solution on my own. I have a binary table like this: <tbody> A B C D 16C 0 1 0 0 51C 0 0 1 0 17A 0 0 0 1 39A 0 1 0 0 24C 0 0 0 1 16A...

I have a matrix with totals rows and totals columns as follow <colgroup><col style="width:48pt" width="64" span="9"> </colgroup><tbody> A B C D E F G sum 1 3745 2 10629 3...

Hi Team, I'm struggling in developing an ordering system in excel. Can you please help: Below is my data : <tbody> Item Order Closed Sun-29 Mon-30 Tue-31 Wed-1 Thu-2 Fri-3 Sat-4 Seafood 0 85.44 14.24 14.24 14.24 42.72 56.96 56.96 Bakery 3,4 136.08 24.68 21.68 22.68 68.04 90.72 90.72...

Hey, I am trying something with excel.. This is my desired result (of course entered manually for each cell) I want to replicate this entirely with formulas .. In cell A1 =+IF(COLUMNS($A:A)>ROWS($1:1),COLUMNS($A:A)-1,IF(COLUMNS($A:A)=ROWS($1:1),0,ROWS($1:1)-1)) The formula I tried did not...

Hello, I am working on a formula that has many nested IF statements. I am calculating distances from stores, where the distances are in a matrix. Here is a short version of the formula to get from store to store...

Hi, I have a master data set like this: <tbody> Region Country EU France EU Germany LATAM Mexico LATAM Bolivia LATAM Columbia APAC China APAC India AFRICA Egypt AFRICA Libya </tbody> Now, I have a second table with a subset of regions, and I need to populate a 2nd...

Hi! I have 3 columns: <tbody> PRODUCTS SOLD DATE Apple Y 9/24/2013 Apple N Orange N Orange Y 8/28/2013 Pear Y 9/24/2013 Strawberry Y 9/24/2013 Cherry N Cherry Y 9/24/2013 Grapes N Grapes N Pear N </tbody> I need Excel to count only the products who appear once...