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
Sort by Brandon
I have a spreadsheet with about a thousand lines of stock sales for the year. I need to sort by this column alphabetically by the first word after the word...
April 15th, 2010 07:24 PM
by Tom Hutchins Go to last post
2 186
#N/A help please by cadustin
I have tried to correct this formula with the ISNA, and not getting any result, please fix what I am doing wrong! I put the ISNA in the beginning and am...
April 15th, 2010 05:42 PM
by Duke Carey Go to last post
2 202
Help with If Sum statement - i think.... by Scott_goddard
Hi, I need to be able to do the following but i can not quite arrange the formula corectly.... I have one sheet that has all the weeks in coulumns (for a...
April 15th, 2010 05:26 PM
by Duke Carey Go to last post
4 145
Rounding Up question by spreadsheetlady
Hi, A1 has the ROUNDUP Function referenced to B1: ROUNDUP(B1,0). Example: B1 says: 6.2 A1 will roundup to 7. Perfect! This works 99% of the time. But in...
April 15th, 2010 05:20 PM
by Mike H Go to last post
2 160
pounds shillings pence format in excel by peter
I want to use pounds shillings and pence format in excel...is it possible and if so how do I go about it?
April 15th, 2010 05:17 PM
by Bernard Liengme Go to last post
2 225
Ad-In Rowliner by Eurika Stemmet
How do I prevent the background from changing when I use Row-Liner in a protected worksheet. I used the following VB Code, but the backgrounds I used changed...
April 15th, 2010 04:26 PM
by Gord Dibben Go to last post
4 183
Excel IF Formulas by mgreen-NJ
Good afternoon - I need to create a formula in a cell that indicates if that particular cell returns a certain value then the entire row of information...
April 15th, 2010 04:24 PM
by mgreen-NJ[_2_] Go to last post
2 103
Show time as a negative figure by JCR1987
Can someone tell me if it's possible to calculate time as a negative figure. I'm trying to do a calculation where if you work less than contracutual hours it...
April 15th, 2010 04:10 PM
by Hans Terkelsen Go to last post
3 165
Convert percentage into margin by Linda
Here is my quandry and I am probably over thinking it. I have a starting cost of $26.00 with an end cost of $26.54. I need to know the formula that will...
April 15th, 2010 04:06 PM
by Bernard Liengme Go to last post
2 214
how do I import data in excel form SQL server? by Mitch
Hello All, I've been trying to import data into excel from our SQL server. I have the sql script yielding the results. The real problem is when I use the...
April 15th, 2010 03:49 PM
by Duke Carey Go to last post
7 185
Countif/SumProduct by excelllllllll
Hi, ok i have 2 columns.... Column A Column B 32 - 54 20
April 15th, 2010 03:33 PM
by excelllllllll Go to last post
4 143
Directing cell contents to one of two cells dependent on its value by Debi
How do i write a formula that will redirect a cell contents to one of two cells. One for if its less than 36 and one if its over 36. I am using it as an...
April 15th, 2010 03:13 PM
by Gary''s Student Go to last post
1 150
multiple dependent drop down lists by Mikej
Hi, I am trying to implement multiple cascading drop down lists. I have two worksheets: a user one (with the dropdown lists and data tobe displayed) and a...
April 15th, 2010 02:11 PM
by Mikej Go to last post
6 204
Adding a value to a customer ID? by Anne
Hello! I have a case number for a patient. 2009-001, for example, in C2. I also have a contact number for the patient's family member, in D2. How can I combine...
April 15th, 2010 01:43 PM
by Bernard Liengme Go to last post
4 152
Sumif with multiple sum ranges in a sheet by MA
Hi experts, I need to sum multiple columns in a range which meets a criteria in one of the columns of the range. For example C1 C2 C3 R1 ...
April 15th, 2010 01:40 PM
by Teethless mama Go to last post
4 176
Can I combine a Vlookup with an IF formula? by Claire[_2_]
I'm not sure Excel can do what I want it to do - I have a VLookup formula on my spreadsheet which is returning data, however, I only want it displayed if it...
April 15th, 2010 01:35 PM
by Duke Carey Go to last post
2 141
Filldown starting from F2 instead of F1 by Ephraim
Can anyone help me modify the following so that when Col F fills down it starts at F2 instead of F1. It works great but everything in Col F is up one cell too...
April 15th, 2010 01:05 PM
by Ephraim Go to last post
5 146
Setting up an electrical register in Excel with expiry dates by Scotty
I am currently setting up an electrical register using Excel 2003 which shows a date column of when the equipment has to be retested. I would like to have...
April 15th, 2010 11:12 AM
by Mike H Go to last post
1 138
directing cell contents dependent on its value by Debi
How do i write a formula that will redirect a cell contents to one of two cells. One for if its less than 36 and one if its over 36. I am using it as an...
April 15th, 2010 09:58 AM
by Mike H Go to last post
2 187
Pulling/Collating Data by chrisk
Hi, I have a workbook with 31 sheets (diary) A9:F9 (and other rows) is the info I want with the employee's initials in G9 There are multiple entries for the...
April 15th, 2010 09:53 AM
by chrisk Go to last post
4 165
Post New Thread


Display Options
Showing threads 1261 to 1280 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 10:58 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.