Hello Excel Gurus,
I need help developing an Excel formula in the below sheet (Attached). I want to calculate the attached rate for an Accessory as compared to various Finished Goods.
Here Accessory ACC1 is going into 2 different finished goods FG1 and FG2. Typically the attached rate for an...
Thanks a lot, AliGW for the prompt reply.
Yes, this is working correctly.
I even used the formula '=IF(B2=B1,E1+1,1)' in the meanwhile, it gave the same result.
Hi All,
Is there a way to populate column E with the occurrence of the value in column B as per the below screenshot (i.e. 1st occurrence, 2nd occurrence and so on)
Regards,
Siddharth
Hi Srinidhi and AVK ,
Thanks for the reply , but this is normal sorting .
I require the grouping of materials , which have same set of resources.
Lets say I have a group of 5 resources for a material , so I want the grouping to be done for the bunch of materials , which share those 5 particular...
Hello ,
I have 2 columns a. Material , b. Resources.
I want to group Material , which use same set of resources .
Eg material X uses Resources 1 , 2 and 3.
Material Y uses Resources 1, 2 ,4.
Material Z uses Resources 1 , 2 and 3.
So I want to identify Material X and Z together and Material Y as...
Hi ,
Thanks for your reply .
Issues in the solution you provided :
1) We need the conversion to be done for individual entries of the row , not the row total.
2)All the quantities are in Base UoM , so , if Sales UoM = Base UoM , then no conversion is needed .
Regards
Sid
Hello Gurus ,
PFA the sample file.
We need to convert the values highlighted in YELLOW to the Sales Unit of measurement from Base unit of measurement using VBA
IF sales UoM = Base UoM , do nothing to the values of the corresponding row
IF Sales UoM = GAL and Base UoM = L , values =...
Hi Gurus,
I have a requirement as below:
The calculation for the cumulative shortfall is equal to the sum of Shortfall values of Previous + Current month of the Fiscal year 14-15 ( April 2014 - March 2015).
I want the calculation of Cumulative Shortfall to be restricted for the same fiscal...
Hi All,
I have an excel sheet with columns which might have duplicate records when comparing some key fields which I have marked as green. Now the rest of the fields are numeric fields.
I want that columns with numeric values of the duplicate records should get added(total) and only unique...
Hello ,
How to append 0s before a set field of 10 characters when the characters inserted are 4 .
Eg. the field accepts the character length 10 , so ,
if the value is 12345 , for the remaining spaces should pe appended by 0s resulting in
0000012345 .
ab = 00000000ab
monkey = 0000monkey...
Hi Guys ,
I am in a crunch situation.
I want to extract data from a set of strings.
Eg.
Product A123 does not exist in plant 111
Product B123 does not exist in plant 222
Product C123 does not exist in plant 333
so i should be able to extract
Products. A123 ,B123 & C123 in one sheet...