Search results

Please help me achieve this. Material Month Price Latest Price A Jan 10 B Jan 2 2 C Jan 4 D Jan 5 5 A Feb 8 8 C Mar 22 C April 19 19

Can someone help me with a method to identify the ideal price in the below scenario to reach the volume of 1700?.. How to achieve this? Year Price Volume 2018 4.75 1500 2022 6.03 1300

Please help me achieve this! Name Month Sal Average ABC Jan 2 ABC Feb 4 ABC Mar 6 4 XYZ Jan 5 XYZ Feb 10 XYZ Mar 15 10

Please help me achieve this!

I get #VALUE! with this formula HYPERLINK(HYPERLINK(Config!$B$9&"/"&SUBSTITUTE(TEXT(E38,"MM/D/YYYYY"),"/","_")&"/"&ENCODEURL(Config!$B$10))&"/"&ENCODEURL(A38&".msg","Click") Config!$B$9= https://kt001-kt.kell.com/:u:/r/sites/AAFAA3444/Connectivity/Connectivity Controls Audit...

Hi All, Is it possible to open two links at once from an Hyerlink function. Example: =Hyperlink("https://chandoo.org/ "&"https://stackoverflow.com/ ") Thanks

How to achieve conditional average. I need average wherever there is "D" , When there is no "D" then it has to calculate the average for "R1". Thanks santhosha'

Hi All, Please help me on predicting the future values based on the existing to meet the target value. I have explained my problem in the attached workbook. Thanks santhosha

Happy New Year to All... I need to derive the the working hours based on the specific time interval. I have explained my problem in the attached workbook. I need a formula to achieve. I have tried my best but with no luck.your help on this is greatly appreciated. Thanks santhosha

Hi All, Here is a solution that exactly matches my requirement on splitting the file. This split the files based on sale person provided in the column(http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/). After the file is split i want to send out the emails to the respective sales...

Hi All, I have come across a situation where i should be able to do a lookup which can give me the results when it doesn't find a value in particular column by taking a closest match from the same column. For example I have 3 columns Year, month, salary respectively. I am trying to get the...

Hi All, I want to find out the sum of first 3 non-blank cells. If there are more than 3 cells in that particular row means we should do the summation only for first 3 occurrences. Sample file attached. Thanks santhosha

Hi All, Is this something which is possible in Excel,MS Access or SQL? i tried it in different ways using GROUP BY clause.I want to find out the Duplicates(Concatenating Sales Order and Item) with the sequential number.Column 'schedule' is what i am looking for. Pleas help me on this.

Dear All, I am stuck up with the concept Moving average . I have explained my problem in the attached workbook. Please have a look on it and get back to me with some solutions. Your help is greatly appreciated. Thanks santhosha

I have a column with time stamp field which contains the time. ie. 7:10:00 AM. I would like to split this field into 2 fields, one with just the Hours portion ie 7 and the other with just the Minutes portion. ie 10.There are some instances where time-stamp is as follows 18:10:00 AM. I tried Left...

Dear All I want to find the duplicates based on two columns.For Example I have Value ABC in Cell B1 and Value XYZ in C1. This is reversed in second Row means XYZ in B2 and ABC in C2. When I concatenate this It is one and same for me. ABCXYZ and XYZABC. Just the values are interchanged. Now i...

Please help me out on this Here is the data 1 column has sales order no and other column has line number,say for example, clumnn A Column B column C 2500 1 0 3000 1 1 2500 2...