Search results

Hi Srinidhi, As you can see from the formula, values in Row 1 (which is the heading row) is included. I'll share the workbook tomorrow from work. Regards, Ninad.

I have data from A1:K622 and I've created a dynamic range name "lstAuditMasterDetails" =OFFSET(AuditMaster!$A$1,0,0,COUNTA(AuditMaster!$A:$A),11). Row 1 has headers and data beginning from row 2. For the pivot table I am using this range name, but the field names the table picks for the data...

Select and Hide.

@OP: Use the drawing objects. But XL is not best suited for flow charts. You may be better off with Visio. Depends on your purpose.

@OP: can you post a sample file.

Take the table which has the field (Category) you want. Make a query with only the Category field and use this query as your source to the drop down box.

@vijay: definitely a post in the wrong forum. But if I've understood your problem (and correct me if I have not), you can create a dropdown from the menu and link to a query which can display the field values which you desire. In fact, IIRC, you can also use a wizard for this. I don't have...

try the Networkdays.intl formula OR http://www.cpearson.com/Excel/BetterWorkday.aspx

To begin with you could try the Macro Recorder feature.

Try this in cells C7 of the worksheet 'Master' =INDEX(OFFSET('Associate 1'!$B$1,4,1,COUNT('Associate 1'!$B:$B),1), MATCH($B$2, OFFSET('Associate 1'!$B$1,4,0,COUNT('Associate 1'!$B:$B),1),0), 1) and replace "1" with 2,3, etc. as below for the rest of the cells. formula in...

Try this search "combine individual worksheets into single worksheets"

@SirJB7: No worries. But thanks to you for the pointers. Now I can safely sum up my problem in words - MaxIf and MinIf :)

@SirJB7 : "Tip". Didn't get it. Am I missing something ?

@Kaushik03: You can be sure of seeing me here. Ain't going anywhere :)

Hi bobhc, Here's the file. Results are in Sheet3. This forum gives so much. Extremely helpful and most of all, courteous folks around here. http://dl.dropbox.com/u/22668845/WP%20Marine%20Moves%20-%20NP%20-%20Rev%200.xlsx OR http://sdrv.ms/NzaA9d Regards, Ninad.

SirJB7, Thanks for the pointers. I was able to use those posts and successfully achieve what I wanted. Regards, Ninad.

Thanks. I do search first on most occasions. The issue with this post was that I was not able to explain clearly in what I wanted (finding it difficult to put in words), except putting up in the file.

http://dl.dropbox.com/u/22668845/Book1.xlsx

Hi. Sorry for my late reply. But I managed to solve this.

See attached file for details. It's difficult to explain in simple words for me. Appreciate your help. https://skydrive.live.com/redir?resid=EF586DA077D21A56!7747 Regards, Ninad.

Hi, On Sheet1 I have a range A1:D10 (A1:D1 is the header row) and A2:D10 are values. Columns B and C take a value from 1-5, both inclusive. On Sheet2 is a range A1:E5. What I am looking to do is if Sheet1!B2 = 1 and Sheet!C2 = 3, then from the bottom left cell (i.e. A5) go 1 cell right (A5...

Thanks Hui for replying. Essentially what I want to do is format in the Indian currency way (e.g. 1,00,00,000.00) by passing a cell reference value to a function and then apply the format. The reason I wanted to go the UDF is the number could range anywhere from 1 to 1,00,00,000 Each time...

I wish to write a Select Case statement in a Function, say, FormatCell(cell_reference) passing a cell value. How can this be done. Function FormatCell(ByVal Target as Integer) Select Case Target Case Is <=1000 Selection.NumberFormat = "0.00" . . . and so on..... TIA Regards...

@NarayanK991: Now I know why I was getting an error. Thank you for your help. Regards, Ninad.

I saw this on a post on Mr. Excel forum. Sub NameRange() Dim RowRange As Long For RowRange = 1 To 15 Cells(RowRange, "A").Name = "Results" & RowRange Next End Sub I'd like to learn how this can be converted into a function with the following parameters * numStartRow : the row...