Microsoft Excel for PC - Page 6 - Answered Questions & Fixed issues
Problem with columns
In Excel 03, I went to Help, typed in "column" and they had a "add or delete columns" topic. Did seem to answer your question. Very modestly submitted. I ain't no expert, just nosy.
Count the number of open and closed order status per owner
My suggestion is to use a Pivot Table. Follow these instructions:
Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.
Click NEXT on step 1 of pivot table wizard.
For step two you will want to highlight all of the data on your sheet. then click next.
Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet. Next drop another instance of the STATUS field into the "drop row fields here" column. And lastly drop the OWNER field into the "drop column fields here" section. You should now be viewing a report showing you exactly what you were looking for.
Regards,
Joe
Formular to show number and cell references
The formula for A1 is: =SUM(B4,B5)
A2 is: =SUM(C4,C5)
A3 is: =SUM(A1:A2)
To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.
Hope this helps.
Exel files slowly open
Hi Sahil,
This can be difficult to resolve on the first pass because there is so many things to consider. I have no idea what your experience with excel or computer maintenance is. All my training in industry has told me is go for the "low hanging fruit" first (try the easiest stuff first).
1) When did you last defrag your computer. That can be a fast easy fix. I don't know what your operating system is but you may have a defrag program included as part of the system.
2) How much memory do you have installed and if you have added some did it match what you had installed because memory will run as fast as the slowest stick installed.
3) Any other programs running in the background? My antivirous program is scheduled to scann at specific times when I would normally not be trying to be productive with my favorite programs. I have all the memory installed that I can and if my antivirous program is running and I try to do something else my system tempts me to persue fishing instead of computing just so I could use my machine as a anchor.
4) Do you have an infection of malware to contend with? When has the last time been that you scanned your system for system leaches.
5) was there a specific time that the software slowed down and if so what was done to the system at that time. Can it be undone?
6) Are you the only person on the machine?
7) Just how slow is slow? My machine takes 2 sec to load excel - 5 sec to load a spread sheet that I have been collecting data on stocks for 3 years but is a rocket processing the data and developing the individual graphs that is responding to the macros commands.
So is your expectations of the program realistic?
Investigate your issue and try to reason out what could be going on. Collect more data about your system so I can better guess from wayover here.
Normal 0 false false false MicrosoftInternetExplorer4
/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}
Evenif this is not what you wanted to hear please don't forget to rate the answer. I can always learn from your opinion of the service provided.
Thanks
Glad to be of assistance
Formula required
at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.
If not solved pls get me that data as to reference.
thanks
Macro in excel
Open up your Excel and hit ALT + F11. This opens up the VBA editor.You can then right click and click New Module and write your macro in there.
Excel - format cells
change the regional setting in control pannel for number format.
Please rate this post if found useful
I want to make a softphone so plz give me the
You can find what you need here: http://www.filebuzz.com/findsoftware/Free_Source_Code_Soft_Phone/1.html
Now, admittedly, this was an easy search. I'm sure there are others, but I checked the DLs on this site, and they seem to be working fine - and without any bugs attached.
Not finding what you are looking for?