Search results

I have a pivot table, the bottom field is Grand Total, I want this Grand Total at top of the Pivot, How do I do this?

How can I prevent a Worksheet sheet from cut copy & pase ?

How can we apply vlookup in ms Access ? Is this possible?

Hi I am working on a large excel file and want to send only current worksheet attached to mail (Outlook). how i can do this???

I have a cell in text format, I want to convert this cell as number format, which keyboard shortcut should i use ??

I have some values in range A1:A34 between 1,25. I need a formula which highlights the duplicate values. Any help will appreciate.

Name Jan Feb March April May Vikas 120 90 132 138 133 Rohan 140 154 104 166 167 Shohan 135 154 102 147 123 Poonam 111 107 136 162 148 Radha 80 116 148 110 153 Ruchi 92 84 140 101 107 Savita 170 94 106 142 101 Sonam 128 124 156 88 136 Sani 143 125 167 109 102 Sahil 88 159 154 154 127 Ravi 120 139...

How can i change my profile photo of this forum?

please write down a formula to count unique values in col A: 10269 10272 10272 10279 10257 10266 10270 10261 10288 10266 10258 10263 10286 10279 10274 10272 10274 10265 10278 10282 10282 10290 10268 10287 10283 10256 10258 10272 10289 10263 10282 10271 10264...

HAPPY NEW YEAR TO ALL EXCEL MASTERS !!!!!

How can we hide a worksheet so it can't be unhidden? How can we print the workbook's full path and filename in page header ?

A B C D E F G H I 1 Haseeb 5701 9527 2704 2757 6968 6275 7799 2487 2 Nafees 4037 1372 5679 5343 8981 2612 4381 1184 3 Rahim 9751 4885 5790 8188 2445 1193 7138 5300 4 Karim 3574 8885 3462 1886 1975 9535 9985 5655 5 Navin 8781 9780 3591 4435 1470 5047 4528 2375 I want to highlight salesman...

1- I have a range of time values, but when I try to sum them, the total is never greater than 24 hours? 2- How can I protect formulas from being deleted or changed?

Hi there: I have made a dashboard attached to: https://www.dropbox.com/s/7s9c6l7qgiifkwj/t20%20Wold%20Cup.xls is there another better way to fetch the data in dashboard area ??? Pls suggest the simpler formula.

Hi there, I have 12 dynamic named ranges, I want to create a line chart using these named ranges, but I am fail yet, kindly suggest how to insert named range as chart data series. JSK

How to assign Form Controls in LibreOffice Calc? (Linux)

I have a list of dates in col A: 01-Oct-2012 02-Oct-2012 03-Oct-2012 04-Oct-2012 05-Oct-2012 06-Oct-2012 07-Oct-2012 08-Oct-2012 09-Oct-2012 10-Oct-2012 11-Oct-2012 12-Oct-2012 13-Oct-2012 14-Oct-2012 15-Oct-2012 16-Oct-2012 17-Oct-2012 18-Oct-2012 19-Oct-2012 20-Oct-2012...

I have list with duplicate values in col A:A, in col B:B i want to place a formula which return duplicate values from col A:A, how will it possible ?

i just buy tablet for accessing chandoo anywhere, when i insert a sd card in it, it doesn't mount automatically, how will i mount it, i didn't connect the tab to internet yet, i hope most user of this forum used tablets, chandoo too, so i post this question here, please don't mind if i broke...

Hi there https://www.dropbox.com/s/7s9c6l7qgiifkwj/t20%20Wold%20Cup.xls this is my workbook containing master data in sheet2, I want to fetch the values in sheet3 according to check-box selection, I am trying to use offset but I am unable to do this, please help me someone, i want if I...

I have some cells with blue background, I want to replace blue color to green. How it possible?

I have a name list in A2:A15, I want to choose one name randomly using choose function, how will it possible ???

What is the keyboard shortcut for rename a sheet ???

I have a sheet like following - Date Recived Done Scrap Pending 01-Sep-2012 394 290 48 56 02-Sep-2012 3500 3500 0 0 03-Sep-2012 3500 3500 0 0 04-Sep-2012 46 46 1 - 05-Sep-2012 200 200 - - 06-Sep-2012 89 89 1 - 07-Sep-2012 7,525 1,853 3,668 2,004 08-Sep-2012...

VBA part is disabled in my excel file, when i press Alt+F11, It gives no response, how i enable it.