Search results

Dear Excel Genius The below code is exported as a pdf to the mentioned path with the specified range("B3:L37") and the name Q7.value as MMM-YYYY and O11.Value.pdf" here the challenge is O11 cell has the dropdown validation list. Example values are "AAAA BBBBBB","CCCCC DDDDD EEEEEE","FFFFF...

For D13, A13 OUT required 130 from IN. Till A12 sum of OUT is 780, So above 780 matched IN till B12 sum of 906, then 906-780=126*C12+4*C13 For D14, A14 OUT required 140 from IN. Till A13 sum of OUT is 910, So above 910 matched IN till B13 sum of 1053, then 1053-910=143. we take 140 only as we...

I am using Office 365 Excel For Mac. the excel formula is given by @Excel Wizard. I try to convert the same to VBA Code as my worksheet slows where I have 100 IN, Price, and OUT with 10,000 Rows. I need the same output with a faster VBA Code.

First OUT 10 minus from First IN 15 then remaining 5 in First IN Second OUT 20 takes the remaining 5 from first IN, then 15 from second IN 15 then the remaining 11 in Second IN likewise, each OUT Uses IN and is multiplied by the prices which are D Column Values. the below formula gives D...

@Marc L I have filled all the D column Values manually. I hope now it is explained well.

Dear Excel Genius In the attached excel sheet A1 to A26 OUT KG, B1 to B26 IN KG, C1 to C26 Price$. I need OUT KG Price in Column D. Manually I calculated 4 cell values. Also, F Column I mentioned those 4 rows OUT KG on where to occur an IN KG. After finding the IN KG cells, multiply them with...

RM Purchase sheet having the purchase of the raw materials (Date wise Price & Qty) Temporary and Permanent sheets are having the formulations of products (Test) with % of raw materials. Production Sheet, Table Production, Production KG in Column "G", Column U to DP % of raw materials uses in...

Dear @p45cal Thanks a lot for your valuable reply. I have added Price first then Qty to achieve the formula to drag across the right side. But entering the purchase price and quantity is getting confused as the respective columns are located 100 columns distance. Is there any possibility...

Dear Excel Genius The below formula in the excel table, drag across right is not updating correctly. =LET(q,Consumption[Consumption RM01],p,Purchase[Price RM01],s,Purchase[Qty RM01],sa,SCAN(0,s,LAMBDA(a,v,SUM(a,v)))-s,qa,SUM(q)-sa...

Dear Excel Genius I would like to feed some more information about the LET and LAMBDA function and how it works. The below-linked thread has all the information from the scratch on why the LET and LAMBDA functions were created and it is the way of calculations. I am expecting your valuable...

Dear Excel Genius In the attached excel file Production sheet I am using the below formula (DU:FR) to get the Raw Materials cost per kg by FIFO Method. Due to more rows and columns of data the excel sheet is getting slower in the process for each entry. For example, I added 150 recent rows...

Did you forget to attach the file? @petergroft

Dear Excel Genius In the attached excel worksheet, I have PO ENTRY and SALES ENTRY Worksheets. PO Entry sheet has PO Number and it is quantity. The sales Entry sheet has the PO number and the sales quantity. I need a pop-up error alert when the sales entry quantity exceeds the PO quantity...

Thanks @ETAF It is working well when I highlight both cells and then drag it to right.

Dear Excel Genius I have two formulas in cells C3 and D3 and I want to drag the formulas across right up to cell CX. C3 Formula =C5-SUM(Cost_Calcu[[#All],[Cost of RM01]]) D3 Formula =D5-SUM(Consumption[[#All],[Consumption RM01]]) C3 formula needs to drag alternate cells of E3, G3...

Thanks a lot for your formulas @p45cal it is working excellent.

Dear All, Is there any other shorter formula than the below one? to find the duplicates in more than 300 column values? =Countifs(E8:E18,E8,F8:F18,F8.........................................KQ8:KQ18,K8)>1

Check this.

@pecoflyer As per your suggested link, I found the duplicate value where the two columns are having data. But Now the actual data got increased up to 300 columns. For example, I have added some small data like the below picture. As per the below picture Products, 2 and 10 are duplicates as...

@pecoflyer Your idea also working good. Thanks a lot for your information.

Thanks a lot @rollis13

Dear Excel Genius, I have exported massive data from a table of MySql .MDF to Excel. After opening excel sheet the date format is not getting the same in all the rows. I have more than 25000 rows of data. I need to convert all 3 columns' format as "DD-MMM-YYYY HH:MM:SS" See below the snapshot...

Thanks @Marc L

@Marc L Thanks for your code. In my actual sheet Intersect reference in another sheet "Sheet2.range("E10:G11") I don't know how to change the below code line from If Not Intersect([K16:M17], Target) Is Nothing Then to if not intersect(. ) is nothing then. I attached the sample...