how to program a cell ?3922 (3/29/2012 3:59:25 PM) acwai.9ba7228(1) I want to program cell A1 with a symbol + and B1 with a symbol - When I click on A1, I want A2 to increase by 5 min. When I click on B1, I want A2 to decrease by 5 min. Can someone help me ? Thanks ! If pos...
formula #302951 (3/7/2012 8:48:26 AM) y.ranjbaran.99d1cc8(1) hi all i want to write formula for one of my excel column, but it`s complicate. my formula has 3 if in if ! what should i do? -- y.ranjbaran ...
Need help with using Month as criteria for SUM(COUNTIFS(...3693 (3/22/2012 8:57:16 PM) subie2gx.9b18c08(1) Hi all, I am fairly new to excel and experimenting some functions with my project. I have a SOLD datasheet with Sold Date (column W) in MM/DD/YYYY format). I am trying to count the items with a few criteria u...
Re: How to lock cell0760 (3/23/2012 2:58:30 PM) Moideen.9b28928(1) Spencer101;1599778 Wrote: > I -think - it's only possible with VBA. > Have a look at this link for further advice as it's nothing I've ever > needed to do before so cannot really advise myself. > > http://ww...
combobox populating.1724 (3/21/2012 12:10:27 PM) greg5774(1)Hi All, I need to fill a combobox with data I have on a sheet called stock. The part numbers are in Column A. What I would like is populate with the correct amount. I assume if I used the whole column the co...
Please help with last formula for order form.1860 (3/11/2012 10:33:47 PM) juleoni.9a30b88(1) I am able to accomplish this with 1 column by the formulas below. Cell H160 is the subtotal: =IF(SUM(H72:H111)>0,SUM(H72:H111),"") Cell H166 the total: =IF(SUM(H160)>0,SUM((H160*H163)+H160),"") Cell H163 is f...
make a cell invisible2924 (3/17/2012 1:40:54 PM) nospam1735(19)Hello, I have several long columns of numbers. I want to fade, or perhaps make invisible, any number which is equal to the one above. Or, equivalently, to highlight any number which is different to the one a...
changing colour cell and text by clicking cell2917 (3/16/2012 5:41:14 AM) franssen(2)Hi. In a worksheet i have in cells O22::X44 numbers from 1 to 9. Now i what that when i click one of these cells that the cell colour changes to red and the text changes to white Is this possible? Hannes ...
Using VLOOKUP to Sum values from multiple columns1769 (3/15/2012 1:05:38 PM) Askyou.9a7a8c9(1) I am trying to use VLOOKUP to sum multiple values from different columns. I need this because the value is given by name of machine, and in the column directly right of that the cost is given. The table look...
How to lock cell4855 (3/13/2012 7:26:54 PM) Moideen.9a55a28(1) Hi, How to lock a particular cell without locking the whole work sheet Pls help me. -- Moideen ...
Electric Golf Trolleys0667 (3/14/2012 7:56:45 AM) Harmony.kurtis.9a65748(1) While looking for to shop for the best electric golf trolley, shoppers mainly focus on finding a golf trolley that has all important features based on their requirements and preferences. However, a particular ...
Average function for letters3690 (3/8/2012 7:11:16 PM) ZWarren.99ec2a8(1) I am trying to compute a percentage for a range of A4:A24; the only values in the cells are either an "X" or it is left blank. If possible, I am trying to compute the percentage of the whole A4:A24 range wher...
SUM help please7788 (3/4/2012 1:02:03 AM) ExcelNoob123.9987f88(1) I have created a sheet which is tracking 3 items per client and a number of clients so I have set up a SUM function the only way I know how which is a long a1+a4+a7, etc Its works fine, but if I want to add a...
Sharing a worksheet/tracking payment dates1579 (2/15/2012 1:35:39 PM) Nonhlanhla.9816d48(1) Hi, May you please assit. I need to share a worksheet with a fellow employee however I will use it for tracking of the payment dates. Also, I would like to know how do I go about setting up my worksheet in o...
Can This Be Done in Excel?3912 (2/26/2012 6:08:29 PM) giovannashouse.9904228(1) I took a class on Excel years ago but it was not that extensive. I have a small dance studio. Members sign in when they arrive to keep track of how often they come. Some pay dues in advance. Is there a way th...
help with formats please21013 (3/2/2012 12:41:47 PM) nospam1735(19)Hello, I have numbers in currency format, eg �8900.00 which I want to display as �8.5K . Can someone help me with the format for this please ? Thanks KK ...
Just saying hello0668 (3/2/2012 11:27:22 AM) vhookup.9968548(1) Hey guys, I'm new to the forum and just wanted to say hi! I look forward to lots of excel banter with you guys! -- vhookup ...
comments font size1698 (2/29/2012 6:57:21 AM) y.ranjbaran.9938de8(1) plz help I have to increase all comments font size, in excel 2007 in win 7. 1000 comment! how can i increase all comments font-size. without making change one by one?? tnxx -- y.ranjbaran ...