Search results

Hie forum, I have a list of customer wise product wise sales. The customer is in col A and product is in Col B. for customer A, there can be 4-5 different products and the subtotal of sales made is shown. Now the problem I have is that I want to sort the customer wise grand total sales with...

Hie forum, I tried to upload the sample worksheet, but just could not. Therefore, posting my question in text form. I have a sheet which has the Bill of Material details for around 50 FG. The FG code is in column A whereas relevant components like SFG, Chemicals, Fuel, Packing material, Raw...

I applied subtotal for some items in a large range of cells!! When I used the large formula for picking up "n" largest items, I got the correct answer. However, when I tried to use index match for retrieving the corrosponding value, the formula din't work! I tried to manually search for the...

hie forum, I have a value in column C against employee code in Column B. The column C contains the eligibility amount( for the whole year) for the employee code. The employee is entitled to draw some amount against this eligibility every month and I add columns every month , say Col F for...

Hi forum, I was just about to upload a worksheet where I was facing problem when I came across this post http://chandoo.org/wp/2010/11/09/2way-lookup-formulas/ which gave me solution to my problem. My question for better understanding of the problem is-...

Hi forum, Have a sheet with employee number mentioned in col a, col b mentions the serial number of dependants of employee number mentioned in COl A( if employee no. 1 has 4 dependants, den cell A2 to A5 would be blanks and cell B2 to B5 contains the serial number of dependants). Col C...

Hie forum, Stuck up in a problem!!! Have a list like dis-: Col A Col B Col C Col D Col E SrNo. Dependants Emp No Relation Age 1 71 Self 54 1 Wife 48 2 Son 24 2...

Hie forum, I have data with sl no. name and address and other details. The name and address extends to 3-4 rows for a serial number. Is there a formula/shortcut wherein I can specify that per sheet only 11 serial numbers should be printed??? I have the data running into 2000 Serial numbers...

Forum, I am using the basic sumproduct formula with wild card search. I converted the numbers to text as per chandoo's previous post on sumif. However, I am getting 0 as an answer. Any ideas??. The formula I am using is...

hie forum, I have a worksheet with 15 columns and 5000 rows. I have to apply filter on 2 columns specifically wherein if either of them has a number<>0, the other column should also show even if the value is 0 and the other relevant columns corrosponding to it. When I apply...

I have a issue with a lookup function. 1st sheet: Col A COl B A 1 B 5 C 2 D 6 E 6 I want to pick up values if Col B value is greater than or equal to 5 and the corrosponding value against it in Col A. The data then I want is in sheet 2 with values B, D...

hi forum, I have sheet with employees id and bank account against it. The problem i am facing is that the bank account numbers can start with 0's. In that case i cant make excel show the acount nos. unless i make it appear as text. However, for cross checking purpose, it is needed to have dem...

Hie forum, By looking at lot of use of offset formulae in the forum, i tried using one for one of my workings. The data is Month wise with 4 subheadings in each month. I then go on to create a summary sheet with months in rows and 2 subheading amongst the 4 in the master data. I am using the...

Hie forum, Is there a formula or a method wherein, any entry where manual entry is punched, is highlited or picked off. eg if all the cells in a column contains formulaes with very few contianing formulas and adjustements like + some figure. I did try CTRL+~, but then I had to scroll the...

Hie forum, I have a sheet with date in format 16.03.2011. However, i have another sheet with same data but with date in format, 16-03-2011. When i apply vlookup, the formula does not pick up the dates. Is there a way to change the date in the format 16.03.2011 to 16-03-2011. I have some...

Hi, Wanted to ask if the vlookup formula picks up date or not. I am using the formula to vlookup an employee number(number) and picking up date based on that. But it shows NA error. Thanks Nitin

Hie forum, Have a column containing numbers and errors. I want to sum the column with sumif function, but it is not yielding correct result. The formula I am using is-: SUMIF(A3:a100,not(#N/A),a3:a100) Am i doing something wrong???

Hie forum, I have a sheet wid vendors name and excise duty @ 10.3% against dere name. I have andr sheet wid document no. as one col and the ED broken down into its constituen part, i.e. 10, 2 and 1%. Since there is no common data linking the sheets, I was thinking of trying to sum the second...

HI forum, Is there a way to use countif for comparison purposes as explained in chandoo's post of comparison ninza, where the two columns contain amounts but with minor changes due to rounding off. eg one column contains 819 and other column contains 819.6. Thanks Niting

Hie forum, I have some date coming from SAP in this format-: Col A COl B COl C 01-04-2010 Narration 4444 03-04-2010 Narration 5555 05-05-2010 Narration -4444 Now the point is that the positive entry will be knocked off by the negative entry. But the entries happen at different dates...

Hi forum, I have a sheet with colA with job codes and COlB with vendor name. Other information are in other columns , specifically , like amount in ColL. The entry for one particular vendor against one particular job code appears many number of times in the sheet. Now, in other sheet, i wish...

Hi forum, I used a formula in cell F2 like IFERROR((SEARCH(F$1,$A3)>0)*$D3,""). Now copying it across from col F till Col AZ is not a issue. However, i have to copy the formula down till row no 300. Do i have to copy the formula down individually for all columns for col F till Col AZ. or...

Hi Forum, I used a formula which was like if((date in $a$3-date in a2)>366, 28,0) and copied it across the range However, even with cells which had to be subtracted, being blank, the formula produced the result, implying it took the blank cells as some date. Could you explain why it is...

Hi forum, I had read sometime bak in the forum, the macro for deleting alternate rows. I tried searching for it, but could not find it. Could u share the Macro and could we also apply the macro for particular ranges instead of the whole sheet??? Thanks Nitin

Hey Forum, I have a sheet 1 with 3 columns, COl A with A/c codes, Col B with the month Names, Col C with the values. In sheet2 I have col A with A/c codes and row A1 with Month names and I want to poplulate the Col B with values corrosponding to the month and A/c codes in Col C in the 1st...