Search results

Hi Particular excel sheet the delete Option shift cells left & Shift cells Right option not available in particular sheet. Plz help me Thanks in Advance Regards Basavaraj K H

Hi I had used the countif formula in sheet!1 i.e., =COUNTIF(A2:A1048576,"R")& draged from cell A1 to J1. & I want that same result in sheet! 2 in transpose mode (i.e. in sheet!2 cell A1 to A10). Which formula can I write. Plz help me to write Thanks Regards Basavaraj K H

Hi Narayan, I so sorry about that, i would like to have second option that is "All three entries against "Mumbai" and "Orange"" Thank you!

Sorry for the confusion. I want orange under Mumbai with all details like, Qty and Days ( 17, Tuesday). Thank you..

Sorry for the delay in reply, yes i just want to know the difference between Mumbai orange, Bangalore orange Delhi orange and Chennai orange in same way for all the fruits.. Thank you!!!

Hi I want to run VLOOKUP or something, which will show me the both columns( Cities and Fruits ) as a base. As we see in this DATA and DATA1 there are apples available in different cities but Qty and Days differ, so I need to generate DATA which can differentiate between apple of bangalore...

Thank you Chandoo... :-)

Hi, I need a nested formula, Data's are stated below: In column A = City Name ( Bangalore, Simla ), Column B = City Code 1,2 and 3 and In column c = Amount. I need the sum of amount for city code 1 for Bangalore city. Thanks.

Could you please help me out in the following options to have an VBA macro run with codes. A. I have a MS.word document which is arrayed as mentioned in the attachment. I want a formula or a code wherein I can tag Ms.word document to Ms.excel with VBA coding or a formula to do this. B. I...

Thank You both for Great Help

Hi Can some one help me out from this problem. I am new VBA macros. I have data like Date, ID, Last name, First name, and Middle name in the word document. I want to convert into excel sheet with the help of VBA Marcos. Example :- 10/12/2011 80997 Augustin Helene Anesthesia...

Thank you very much Luke

Thank U Luke, but your solution works in cell L2, Just I Edit your formula like below =IF(AND(OR(I2="PROGRESS",I2=" "),K2=" "),"PENDING",IF(AND(I2="COMPLETED",J2="DONE"),"COMPLETED",IF(AND(I2="COMPLETED",J2="PROGRESS"),"PROGRESS","PENDING"))) I want write above same formula in K2 cell...

Sorry I did't get the answer My client condition is like below if i2="COMPLETED" & j2 ="DONE" then k2=COMPLETED i3="COMPLETED" & j3 ="PROGRESS" then k3=PROGRESS i4="PROGRESS" & j4 ="BLANKS" then k4=PENDING i5="BLANKS" & j5 ="BLANKS" then k5=PENDING Oldchippy has answered...

Hi Please help me to write a IF formula for below condition in attached file Cell K2 BINARIES STATUS COMPARE STATUS BINARIES & COMPARE STATUS COMPLETED DONE COMPLETED COMPLETED PENDING...

Thank you for your information. To add the fuel to arguments, please let me know about - in the V B Editor is't possible to get the string to rev string by going through "V B Editor>Insert>user form>Textbox1 & Textbox2"? for same above e.g. - ABCD#?1234 to 4321?#DCBA. There I...

Hi How do I change String to Rev-String My Question is for ex: ABCD#?1234 I wanted it's in reverse see 4321?#DCBA like that. which formula can I use. I want both formula & VBA code also. Plz help me Thank in Advance Basavaraj K H Member of Chandoo.org

Solution To sort the outer field in descending order by subtotal, follow these steps: 1. Double-click the field button for the outer field in the row area—the Prospect / Opportunity field in this example. 2. In the PivotTable Field dialog box that opens, click the Advanced button. 3. In the...

Sorry I did'nt get the answer. My clint condition is like below Jagadamba is in A1 Cell #N/A is in B1 Cell Service is in C1 Cell I want write formula in D1 cell & 2nd Question is Jagadamba is in A2 Cell is in B2 Cell (blank Cell) Service is in C2 Cell 1st Questions: how...

Hi How do I -Join the Cell A1 B1 & C1, When B1 is #N/A & B2 is Blank how to apply the formula, by using if or concatenate or some others formula. A B C D 1 Jagdamba #N/A Services =? 2 Jagdamba Services =? Plz send me Answer. Regards Basavaraj K H...

How to put the if condition formula in calculated filed? in pivot table, Excel 2003 My clints condition is 98-100 0% 96-97.9 10% 93-95.9 30% 90-92.9 50% 85-89.9 65% <84.9 No Incentive & I applied formula like below...

Hi How to run the formula in the Pivot Table, Excel 2003

Hi Plz send me answer to this question How to run the formula in pivot table, in Excel 2003. Basavaraj K H basavarajkh@ibibo.com 9902888801 Bengaluru Karnataka

I am Basavaraj K H from Bangalore Karnataka right now I am working with Jagdamba Infosys (Medical Transcription) as a M I S Executive working with Excel. Chandoo This is a great website with such a helpful community of contributors; I've learned so much from this site. Thank U lot of...