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 do i get Excel not to drop my 1st zero (02360) by Yaesu Man
I have been trying to type in zip codes that begin with the number 0 in the the 1st number. How do I get it to stay in there?
August 6th, 2008 03:13 PM
by Fred Smith[_4_] Go to last post
5 91
sort when using VLOOKUP by Kathie
My sheet has a VLOOKUP set up to fill in name and Biller when client number is entered. We use this to post checks daily with amount and invoice number. I...
August 6th, 2008 03:11 PM
by Fred Smith[_4_] Go to last post
1 125
Finding a value or the one next to it in a range NOT array by advanced novice
Picture data in a phone book with 5 columns of names and numbers 10 cols total. I need a function that will look up the name and return the number that will...
August 6th, 2008 02:54 PM
by Pete_UK Go to last post
3 104
Multiple Vlookup by Iriemon
I found another post with the following solution to my problem, unfortunately, I am not understanding how this works. =INDEX(C1:C100,...
August 6th, 2008 02:53 PM
by Iriemon Go to last post
3 122
Sort of subsheet by Pyrite
I know you cannot have subsheets in Excel as it is not a hierarchical system. I wondered if there was anyway of generating a similar end result though. I...
August 6th, 2008 02:28 PM
by Pete_UK Go to last post
3 114
formula drag down when using filter in 2007 by CAM
When I use the filter function, sometimes the formula works on visible cells only and sometimes it fills in the cells which were filtered out. How do I only...
August 6th, 2008 02:18 PM
by CAM Go to last post
0 136
Lookup or...? by Lene
Hey, please help an norwegian with a excel-problem.. I have a table where I want to bring back a value from another table (f.ex weeknr). I have the value...
August 6th, 2008 02:15 PM
by Bob Phillips Go to last post
3 107
How do I create a formula to add to a cell value, up to a set maxi by JWmadrid
Hi, Am having problems creating a formula, although I'm sure its fairly straight froward! I need to create a formula in cell b1 that will check the value...
August 6th, 2008 02:13 PM
by Glenn[_6_] Go to last post
3 163
return 4 lots of data when a corresponding number is entered by shrek5000
I am attempting to retrieve 4 different answers when a postcode(zipcode) is entered into a cell, data is stored in a 2nd worksheet within 5 columns, when the...
August 6th, 2008 01:19 PM
by Pete_UK Go to last post
3 135
Replacing cell reference on multiple sheets in one go.... by neilcarden[_12_]
Hey, I am needing to change a referenced cell on 31 worksheets in one go if possible. On each sheet cell D19 equals C89, I want them all to equal C91 now? I...
August 6th, 2008 11:20 AM
by neilcarden[_13_] Go to last post
3 125
Get vaçues in multiple sheets by Carpe Diem
Hi, I have a file with 15 sheets, and I need to get 10 type of values each month accordin one or two conditions. So I use sumproduct to get thios values for...
August 6th, 2008 11:13 AM
by Carpe Diem Go to last post
0 87
update workbook by MAANI
Is there a way to update a workbook that has links to other workbooks without closing the file,reopen it and click update??
August 6th, 2008 10:50 AM
by Gary''s Student Go to last post
1 121
How do I find out date of birth from an age? by [email protected]
I have a person's age in one column, and in the next I would like a formula to show to when that person was born (obviously the iyear/ i when that person...
August 6th, 2008 10:47 AM
by [email protected] Go to last post
8 146
Automaticcly insert rows by Tia[_3_]
Hi I am working on a time sheet each employee has his own sheet to make his daily data entry till now i have 45 sheets regarding the projects that they worked...
August 6th, 2008 08:47 AM
by Tia[_3_] Go to last post
0 109
Vlook Up by dcb2
I am having trouble understanding vlookup. Is there a tutorial for this function? What is the best way to figure it out? I have tried using the help, but...
August 6th, 2008 07:13 AM
by T. Valko Go to last post
1 85
Validation question by ComicFly
Is there a way to creat a drop down list where each item has a definition, but when you pick that item only item appears. Example: 03 - Net 30 days ; 04 -...
August 6th, 2008 05:21 AM
by T. Valko Go to last post
3 112
My rounding error in a simple IF by garron
col:A col:B col:C col:D col:E 4.82 -.02 =4.80 vs 4.80 =0% why am i getting an error...
August 6th, 2008 04:11 AM
by T. Valko Go to last post
2 95
please try this by driller
First of all, i hope this is easy. Is it possible *?* to have a subtotal() formula in a column that can count the cells like; Formula 1) count the visible...
August 6th, 2008 03:23 AM
by Peo Sjoblom[_2_] Go to last post
6 112
How do I compare two columns and return a number count by 9274211
I've got a list with two columns with number values that I need to compare. Eg. compare column A with column B for each single row. Count the number of rows...
August 6th, 2008 03:05 AM
by 9274211 Go to last post
2 94
DP jog macro. by Aaron
Hey gurus, I have had a prob for a while and thought I had sussed it but have now realised im not quite there. ActiveSheet.Unprotect ...
August 6th, 2008 02:54 AM
by Aaron Go to last post
5 179
Post New Thread


Display Options
Showing threads 22001 to 22020 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 01:13 PM.


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