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 Reverse Sort Order Last Post Replies Views
=IF formula #NAME? error by Access101
All three of these are wrong, I can't think of a fourth: =If(instr(A1, "test"), "Y", "N") =If(instr(A1, "test")=-1, "Y", "N") =If(instr(A1, "test")=True, "Y",...
December 1st, 2006 01:54 AM
by Max Go to last post
1 63
Hide Rows - copy and paste only rows that show by Access101
Hello, If you could tell me how to do the following it would be appreciated. If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are showing. If...
March 1st, 2006 01:39 AM
by Max Go to last post
3 189
Trying to compare data in two columns... by accessgrits
I have two columns of data, one for serial numbers I have sent out, and one where extended warranties that were purchased. Instead of always using the find...
May 12th, 2005 06:32 PM
by Biff Go to last post
5 97
now() by AccessHelp
Good morning, How can I make the now() function static? What I am trying to do is we submit our timesheet every week. I have a macro set up to write the...
October 27th, 2005 08:51 AM
by topola Go to last post
5 179
Cell References by accessnovice
I would like to be able to click in a cell and have it take me to another page in the workbook - Any suggestions? Thank you.
December 22nd, 2009 04:12 PM
by trip_to_tokyo[_3_] Go to last post
3 92
Need Function to look up value and return a text value? by Accestimator
I am using Excel and I need a function that look up a valule in column A and returns the Text value from B, C, and D. Here is what I am doing I got 8 sheets...
August 28th, 2006 01:36 PM
by shail Go to last post
2 49
vlookup with lookup value of different length by accl
sortkey value 80101 10 80102 20 80103 30 80104 40 80105 50 80106 60 80107 70 80108 80 80109 90
May 17th, 2005 09:23 AM
by Go to last post
3 91
Want to use trend() and linest() but some cells are empty, #N/A, o by ACcompressor
I want to use trend() and linest() on a range of data but it returns "#Value!" if there are empty cells or cells with #N/A, or "" in the "known x" or "known y"...
May 3rd, 2006 12:48 AM
by Harlan Grove Go to last post
1 85
How do I get worksheets in name order within a workbbook? by Accoounting 2008 Pro
I added the months at different times, so that is the way they listed. I would like for them to Jan, Feb,Mar instead of Dec, May, October
January 19th, 2009 02:52 AM
by Mike Rogers[_2_] Go to last post
1 67
Sheet Names by Accor
Hi all I have a spreadsheet with around 20 sheets; sheet1, sheet2, sheet3 etc. Is there any shorter way to re-name them either from a list or let's say call...
August 14th, 2008 06:13 PM
by Gord Dibben Go to last post
4 105
excel 2003 by account via OfficeKB.com
am having a problem with a formula: It says to do under data, validation, and in settings under allow choose custom then in the formula box, this is where the...
November 8th, 2005 08:55 PM
by account via OfficeKB.com Go to last post
2 126
Adding duplicates... by accountant
I need help figuring out a formula to add duplicates as follows: I have 3 months of figures with duplicate names on each month. I need to add these amounts...
July 23rd, 2008 10:40 PM
by Spiky Go to last post
1 78
Formula for adding 2 worksheets by accountant
I need to consolidate 2 worksheets on another separate sheet. What kind of formula can I write that would include new names on the 2nd worksheet. Say, the...
July 9th, 2008 04:22 PM
by Rich W. Go to last post
1 80
combo box by Accountant
How do you add the scroll bar to the combo box?
September 14th, 2007 12:48 AM
by FSt1 Go to last post
1 57
how to creat a selection pull down window? by accountant2005
if I can select a name from the pull down window, it could save time for repeating key in. anybody now how to create a pull down window? thanks
September 30th, 2005 12:53 AM
by Paul B Go to last post
1 84
functions/formulas by AccountantPB
How do I reference the formula above and get the result off 101 rows below that formula? I need to reference every 101 st row but put the information one row...
May 13th, 2005 03:05 AM
by Bernie Deitrick Go to last post
2 130
FILTERS by ACCOUNTING GAL
WE HAVE 15 PEOPLE SHARING AN EXCEL WORKSHEET WITH ABOUT 12 COLUMNS. DATA IS CONTINUALLY ADDED ALL DAY LONG. FOR SOME REASON THE FILTERRING TABS WE SET UP IN...
March 5th, 2009 02:59 AM
by Gord Dibben Go to last post
1 61
Statutory Hrs Calculation by Accounting Student in BC, Canada
I have a payroll timesheet tracking hours worked, with rows corresponding to the names of employees and columns corresponding to dates of the pay period (14...
October 28th, 2009 07:03 AM
by Accounting Student in BC, Canada Go to last post
0 123
copying formulas only by AccountingStudent
i have windows vista and excel 2007. I created an IF formula in one cell and want to use the same formula down the column but referencing other...
October 29th, 2008 06:55 AM
by ShaneDevenshire Go to last post
1 56
scroll with arrow keys problem by Accounts Diva
When using the arrow keys to scroll down a spreadsheet, I find the active cell disappears below the bottom of the screen. I have to use the scroll bar at...
September 4th, 2008 03:37 AM
by Peo Sjoblom Go to last post
1 64
Post New Thread


Display Options
Showing threads 1061 to 1080 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 12:28 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.