basically

Hello - this is my first post on this forum ! I might not be an excel Master, but I do work a lot with it and on pretty complex formulas, but on this one I feel stuck, close to a solution that eludes me everytime :). I have attached a file with the data and the desired outcome. Basically I...

Dear mrexcel community, I'd like to share my first question in the forum with you. What I am trying to do is summing up different item quantities by week and put in sheet 2: <colgroup><col><col><col></colgroup><tbody> Sheet 1 desciption Qty Date Item 1 5 1/01/2018 Item 1...

<colgroup><col span="2"><col></colgroup><tbody> A Current Month of PW B CODE C PNC 1 9 SF-AY1-0001-K1-1 2 7 SF-AY1-0002-Alindra-1 3 9 SF-AY1-0003-K1-2 4 0 SF-AY1-0004-K1-3 5 0 SF-AY1-0005-K1-4 </tbody> I Basically want only the codes which have current Month of PW as...

Good morning, I am aware that a Pivot table is probably the best option for this, but basically the field listed where the data selected is a drop down and as I cannot get the Pivot Table to check the cell in order to filter different data I feel this is the best way however I cannot get the...

I am writing a simple string of code and continue to get an Error that reads "400." I found a thread that addressed this, but thought maybe it had something to do with the code. Sub Worksheet_S10() 'Activate Workbook Workbooks("Workbook1.xlsm").Activate 'Activate Worksheet...

Hi community, please bear with me this is my first post. I do have basic VBA knowledge but Im struggeling to achieve the following. I do have curve of forward pts from bloomberg or reuters as you can see from below html code. What I try to generate automatically is the yellow area. Basically...

Good evening all, Im having small issue trying to get my head around a league table i have to make... Basically there are 84 teams who need a specific KPI ranked daily for the rest of this month. Basically the bottom 10 drop out daily and can only enter if they are in the top 10 at any point...

I want to be able to type 1310 and have it recognize it as 1:10pm. but not have to enter the : when putting in the value. basically so it still shows as a time but I don't have to type the : when typing the numbers. what format would I use?

=IF(AND(MONTH(N3)=C3,YEAR(N3)=D3 ,H3,0)+AV3+AY3 (This formula works) I want to add to the below as part of the top formula If (And(Month(AQ3) =C3, Year (AQ3)=D3, H3,0 + AS3+AV3+AY3 Basically I am asking if the original invoice is in October and the add the original invoice amount H3 to AV3 +...

Good day everyone Can someone please help me with the following... <tbody> A B 1 <tbody> http://www.xyz.co.za/ProdImg/AA13NDfl1uuL2c.jpg </tbody> <tbody> http://www.africaestore.com/esquire/AA13NDfl1uuL2c.jpg </tbody> 2 <tbody>...

Good Day I have a data feed from a supplier which I imported into excel. I want to take their prices from the "Price" column and use VALUE on it because it seems to be a string. Now, VALUE works fine on all values except when the value in "Price" is higher than 999.99 So basically I get the...

Hi If I format a cell like hh:mm then the cell will accept time like 8:00 and also 14:00. so the hh Is basically from 0 to 24, am I right?

Hey all, would really appreciate any help you could give me. Table 1 I would like to lookup the date in column C to see if it matches the date in column B in the table below (Table 2), and then check if the time within the same row is within +/- 5 minutes of the time in Table 2's column C. If...

Hi there, I am some what of an amateur excel user, but i am trying to design a packaging planning board for my manufacturing facility. Basically i am trying to create a front page that my customer relationship managers can use to create a bill of material, bulk issue and reconciliation...