excel & ilogic

# How to sum with unique Invoice Number wise ????? - Pleased Solve this query for formula ......very usefully trick for sale bill fill. like single invoice & two or more products in this sheet... problem is how to sum product based on unique Invoice No. - Pleased Help !!!

Show Result : 3 (Pleased Show this Query........................................)

id like to ask for help please, will it be possible to count instances separately? Please see example below. Please thank you <colgroup><col><col><col></colgroup><tbody> Duration Time Status 0:30:01 10/11/2019 13:00 Break 0:16:01 10/11/2019 20:00 Break 0:51:01 10/11/2019 21:00 Break...

I do have Excel sheet in which I have inserted IF formula, i.e.=IF(C23='Data Nifty'!$AD$2,"CMP"," ") use of erlier derived "CMP" as above mentioned, is done in another condition i.e. =IF(A23="CMP",VLOOKUP($D$3,'Data Nifty'!$N:$Y,7,FALSE)," ") now the problem is, if CMP gets change with other...

Hi, I’m hoping someone can help me out, on the Greater than 5>< tab I would need it to appear as “>5” if it’s greater than 00:05:01 (HH:MM:SS) apparently VLOOKUP won’t work on it even though It’s on the same format; your help is greatly appreciated <tbody> Longest Wait Time Service Level...

Hi I'm trying to Count Release Date and Release Shift Based on Time of Sampling Release Date will be 27 hours after the time of Sampling Shift to be decided by time boundaries (If time is between 0800 and 1600, shift A, 1600 to 2400 Shift B, 0000 to 0800 Shift C.) If after 27 hours Sunday has...

I am wondering if there is a way to search for a specific value in a column; then if the value is found highlight the entire row and copy it to another sheet or workbook. I know that you can do this manually, I was just curious if there was a way or writing a line of code or a string of macros...

<tbody> Hi All while calculating the average balance for my working I need to use the last working day of the month, however If the month end does not fall on the last working day, the average balance is not correct. For example, if 29th is the last working day of a 31-day month, the average...

Hi I hope you can help me. I have a sheet that contains 3 columns, Label, Chip and Date, the label column can contain duplicate data if this occurs i need copy this date in the next row that contains the same label. Example: Label Chip Date 133 9871452 09/05/17 133 8971453...

I have a diseases dataset saved in MS Excel sheet, the format of the data is given below: I have a diseases dataset saved in MS Excel sheet, the format of the data is given below: | Object Name | Symptom 1 | Symptom 2 | Symptom 3 |...| Symptom N | Disease...

Hi MrExcel, I am in confusion to fill the color of cell. Actually I have some serial numbers in Column A where few serial numbers are in yellow highlights and in Column B I have those same serial numbers but few cells values are not matched and in disorder format in comparison of Column A. What...

Hello, I am looking for a formula to show "Wk 1" for seven consecutive dates and than show "Wk 2" and so on till the end of the year date. The example is shown below. In this case the fiscal year starts from Feb 01 of current year and end Jan 31 of the following year, this is a retail calendar...

Dear all, I have the duration data for more than 40000 rows in the number format. I need a method to convert the same into time format in excel. BY saying number format i mean 1 Hours & 45 minutes has been given as 1.45. I would like to have the same value 1.45 in the TIME format in excel so...

Hello Everyone, I am new to excel and looking for some help in identifying ways to pull "Turn around time"between two dates. But that is not all it needs to fulfil multiple conditions on different column for example Year in Column A ,Month in Column B, Data Validation in Column C We dont have...

Hi, I have below table1 (sheet1): <tbody> <tbody> StartDate(A1) </tbody> <tbody> EndDate(B1) </tbody> Month(C1) Quater(D1) Year(E1) <tbody> 29/07/2012 </tbody> <tbody> 25/08/2012 </tbody> 1 Q1 <tbody> 2013 </tbody> <tbody> 26/08/2012 </tbody> <tbody> 22/09/2012...

In column J, I would have numbers ranging from 0 to 999, or #N/A (the cell is not a text #N/A, but a formula). I need an excel formula that would produce Submit if the value in column J is #N/A or greater than 9. Else it would produce Hide. The formula I am using -- If the value in column J...

Hie all, Basically i am creating a excel sheet where i would be required to have random numbers in a particular range and in multiples for 5 and all the numbers generated should have the total which is entered. Let me elaborate Input Number- 136400 Random Numbers Range- 12000 to 15000 (Range...

<tbody> Slabs (Purchases) Discount Applicable on HIGH VALUE PRODUCT 0-99 0% 100-299 1% 300-499 2% 500 and Above 3% </tbody> Conditions: 1. To avail the discount, the purchase bill has to be in the limits mentioned above,a minimum of 100 RO of higher denominations Example below...

Hi Guys, i need help on below Scenario how to count total no of hrs in total hr cloum which formula we should use for this matter please help me any expert in excel. <tbody> training1 training2 training3 training4 Total hr 1 hr 2hr 30 min 40 min 4.10 min </tbody><colgroup><col...

hi all i have one question related to excel formula example in A1 cell "Equity" and A2 cell "Bond same in B1 "15%" and B2 "3%" <tbody> Equity 15% Bond 3% </tbody><colgroup><col><col></colgroup> <tbody> i just want the formula that if euity is below 10% or bond below 5% then it should be...