Search results

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...

Hui, The worksheet looks like dis-: (Sorry tried to upload the file, but was not able to) A B C D E F G Row 1 Class Desc APC BusA APC Fy DEp FY Acq Row 2 ROw 3 2000 Build 110220 BP01 720 500 100 Row 4 Row 5 2000 Build...

YES Master, Point taken. In the process of developing more clarity. So hopefully would be asking excel right questions to achieve right results. :)

Thanks Hui, It worked. BTW was just wondering why some formulaes work sometime and y sometime not. Does it have to do with formatting of the numbers and text in the sheet???

Thanks Hui, After the post, I also thought that I could use the helper column and use it on Monday in the office. Your post just put any doubt in my head to rest. Thanks again.

HUI, i am sorry. But just not able to get the result. You mentioned to paste the code in the upper pane on the right. There was just a blank dark space and nothing could be pasted therein. So, I explored the contents and found that under the VB, Insert command, Module is there. I used that and...

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...

Luke, Similar to the query above,I also have a situation wherein I have to retain rows if there is a value/text in a particular column. If the column entry is blank, I would like the row to be deleted. Thanks in advance Niting

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...

Luke, Hie!! Thanks for your reply. Luke, what ever I have learned in excel is courtsey this site. However, I have never ever used Macros. I go to Macro tab under the developer tab and when I type the macro name, the create tab gets active. Then it shows the screen with start sub and end sub...

HUI, Forgive me for coming again on this post!! I was asked by a friend for the problem and I gave him the solution proposed by you. I did not have the need for it and for that matter have not used macro till date. Hui, now I am in soup. I have few sheets coming strait from the SAP which...

Luke , Makes sense totally. However, one doubt is there-: the small function acts as the main operator. However, how does the formula works when the 3rd smallest number is repeated across the range and it also meets the criteria of >5. eg, 9 repeated across the range and diffrnt...

MAN, HOW??????I know u can anything with excel but u seriously make it believe. Luke, could you please , please , explain the formula . I have to understand it and explain it to some 1 else(my boss). Thanks Nitin

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...

sorry hui, did not read d last part of ur comment. it works. Thanks using dis sheet i create a master sheet. However, when i recieve the sheet from our units, dey come hardcoded as text. and if i do simple, B1=C1 against an employee code, it shows false. How do i deal with that situation...

Hui, afraid, it does not work. with the format when i start a number with lading 0, it still shows the number without the leading 0. Thanks

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...

Hi forum, The qstn related to the topic, dats y posting here. I beieve dat offset can be used to change dynamically the sum range, i.e. if month wise values r dere till june, dan wen july values r inserted, d offset automatically considers it and sums it. I tried lookin fr a solution, but did...

Hui, Looking at your reply, i got the idea dat dis could also be executed through Index, Match and so i tried using that. But the formula yields #N/A. The formula i used is-: INDEX(A2:A10,MATCH(B12,Data)) Is there something I am doing wrong or Index Match could not be used in dis case...

Hi XLD, Th data is like below-: APRIL MAY JUNE ---- B C D E F G H I J K L M-------COLUMNS 20 200 10 30 30 300 20 40 40 400 30 50 I create a summary like dis-: B B*C April SUM(OFFSET(B$5,,N52,37)) May...

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

THANKS A LOT!!