Recent content by jskushawah

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?

Thanks bob

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

I have 2 tables, tbl1 and tbl2, in first table i have following field: Emp_code Emp_name Basic Hra Convnc. other tble2 have the same fields, now I have an Emp_code in tbl2 and want to fetch all related values from tbl1 for that emp_code , how can I do this using join ?? thanks in advane.

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

Thanks to amrit1186, NARAYANK991, Excel_Kid_663

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

yes it is really very good !!!!

Sir Actually one of my friend is facing interview, and this was his question, so I put pls do fast ,thanks for ur response ...

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

Yes Supero... actually i was looking such an array formula .. thanks for your revert...

Thanks Narayan

yes it works !!!! Thanks Narayan ...