A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
How to VLOOKUP in XCEL across different workbooks each named diffe by kool
I am trying to set-up a VLOOKUP in one workbook to find data in other workbooks, each with a different filename. The location of the files is the same. I...
June 22nd, 2009 09:19 PM
by kool Go to last post
4 200
SumProduct by judith
I know that there are loads of similar questions posted but I just dont seem to be able to figure this out. I am trying to use =SUMPRODUCT('order...
June 22nd, 2009 09:12 PM
by Steve Go to last post
3 142
Autofill Colour by Kanmi
book1.xls has update link to the database through "function query" mean whenever there is changes in database file book1.xls automatically run update it...
June 22nd, 2009 09:09 PM
by Kanmi Go to last post
2 115
Why is there no Freeze Panes option in the Windows drop-down box? by PortNatal
My colleague has no Freeze Panes in his Windows drop-down box. He has forwarded the same spreadsheet to me, and I do have the Freeze Panes option when I open...
June 22nd, 2009 08:58 PM
by Gord Dibben Go to last post
2 127
Re : How to lock a cell once the value is entered by Andy
Hi - I want to lock the cell once the value is entered by the user. i.e. for example, if somebody enters 1 as value in a cell, it should not allow the user...
June 22nd, 2009 08:44 PM
by Gord Dibben Go to last post
2 117
sumproduct issues by Steve
morning all. Ok, I'm using sumproduct for a specific problem and I'm getting back a miniscule value of 5.17E-13 as my difference. The equation is:...
June 22nd, 2009 08:02 PM
by Steve Go to last post
2 102
varying a cell and seeing the outcome by mikebo
I am a fairly regular user of Excel and I can find my way around, but now I have question that I need help on. I have set up a fairly complex sheet that...
June 22nd, 2009 07:04 PM
by mikebo Go to last post
2 163
Autofill issue by Jean
I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to...
(Multi-page thread 1 2)
June 22nd, 2009 06:17 PM
by Jean Go to last post
10 196
Time management by OKY
Hello, I have a new job and to make it easy I need to have a worksheet where I can track my service technicians. In other words we have technicians who are...
June 22nd, 2009 06:10 PM
by Luke M Go to last post
1 104
Automatic Colour Control by Kanmi
book1.xls has update link to the database through "function query" mean whenever there is changes in database file book1.xls automatically run update it...
June 22nd, 2009 06:08 PM
by Kanmi Go to last post
0 87
How to link different worksheets into the 1 menu on a septerate sh by cregs
Hi I need to create 1 worksheet that will have command buttons that will allow the user to click on these buttons, however these buttons will link to...
June 22nd, 2009 05:37 PM
by Luke M Go to last post
1 94
Auto update between two workbooks by Kanmi
Wow! You are Amazing creator. Thanks so much. It working. I apply it to just one cell and it working but I want apply it to the rows without changing the...
June 22nd, 2009 05:28 PM
by Gav123 Go to last post
1 102
Excel "Exact" Function by Bryan Gnidrah[_2_]
I have a worksheet in which I want to compare the data in one cell (A1) with that in another cell. The cell which is to be compared against is immediately...
June 22nd, 2009 05:27 PM
by T. Valko Go to last post
3 113
Auto update between two workbooks. by Kanmi
I'm working on Excel file called destination.xls then i want to call up another workbook source.xls to automatic update destination.xls on some rows. I mean...
June 22nd, 2009 05:04 PM
by Kanmi Go to last post
4 115
Ranking with duplication and gaps by Goody
I have a column of number that are in an irregular sequence (e.g., 1, 1, 3, 6, 1, 7, 7, 7, 9). I need a formula that will determine the highest value in the...
June 22nd, 2009 04:39 PM
by Bernie Deitrick Go to last post
5 139
Validation Data and Looking Up Cells by FredK
I have created a table that has the following information (example) Category Contractor Address1 Address2 Phone Number Fax Number Estimator Plumber ...
June 22nd, 2009 04:01 PM
by FredK Go to last post
1 114
Max Value - based on a time period by Chris26
Hi I have a number of data vaules (Col-B) per day for a number of years. Is there a formula that I could use to extract the MAX value of Col-B for say, Year...
June 22nd, 2009 03:53 PM
by JoeU2004 Go to last post
3 119
auto update function from workbook to another worksheet by Kanmi
I'm working on Excel file called Safetylight.xls then i want to call up another workbook call book1.xls to automatic update safetylight.xls on some rows. I...
June 22nd, 2009 03:53 PM
by Kanmi Go to last post
3 101
Formula to auto calculate based on other variables by Scott A
Hello, I am trying to come up with a formula to calculate costs based on another set of values. Cell C7 is automaticaly inserted into the spreadsheet off of...
June 22nd, 2009 03:10 PM
by Scott A Go to last post
8 163
Locking data between worksheets by mamorellana
I have an excel 2003 worksheet (main) linked to several worksheets (secondary). I want to retain the actual values in the secondary worksheets whenever I...
June 22nd, 2009 02:58 PM
by mamorellana Go to last post
0 106
Post New Thread


Display Options
Showing threads 9901 to 9920 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.