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
Lookup function for two variables and return another cell? by dcw0405
Hi! I am looking for some help. Seems pretty simple but I can't seem to figure it out. I know I'll need a lookup function and an "AND" function of some...
February 4th, 2010 06:23 PM
by T. Valko Go to last post
2 111
Averaging with IFs by John
I am trying to average data if it matches a criteria and if its greater than 1. A B C Team 95 ...
February 4th, 2010 06:08 PM
by John Go to last post
2 101
Cell =Now() Can I get this to auto-update? by Paul Kraemer
Hi, I am using Excel 2007. In one cell, I entered the following formula: =Now() After I typed in the formula and hit Enter, my cell displayed the current...
February 4th, 2010 05:55 PM
by Luke M Go to last post
2 104
How can I count items in a filtered list? by tommy
do anybody know, how to use "countif" with filtered lists? the function subtotal does not allow conditions (e.g. "name") the function countif does it, but it...
(Multi-page thread 1 2 3 ... Last Page)
February 4th, 2010 05:51 PM
by T. Valko Go to last post
33 538
Extract the month name from a month by Grd
Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for...
(Multi-page thread 1 2)
February 4th, 2010 05:45 PM
by T. Valko Go to last post
11 210
Sorting in Custom Alphabetical Order by Raj[_4_]
Hi, I need to sort a list of names in a different alphatecal order eg. D,C,A,B. The Custom sorting in Excel works if I make a custom list of complete strings...
February 4th, 2010 05:36 PM
by Raj[_4_] Go to last post
2 110
If Function by Jen_T
I was wondering if it is possible to add to this formula, if all cell values are blank than formula returns, blank. Current Formula in...
February 4th, 2010 05:33 PM
by Teethless mama Go to last post
1 109
Stoping Excel from Calculating? by John
Can you stop excel from executing any formulas temporarily? Meaning while I update info in the workbook nothing will calculate till I say go? Thanks
February 4th, 2010 05:27 PM
by Teethless mama Go to last post
2 103
Deleting Duplicates by Angie M.
I have a list of numbers in column A as follows: 133150 133150 133150 133154 133154 133154 133155 133156
February 4th, 2010 04:55 PM
by Iriemon Go to last post
2 79
Combine Sumif and Countif by John
I need to combine sumif and countif. I am trying to add up data in a an area say D1:O256 if it matches a criteria. Thats easy. Sumif. Then I want to divide...
February 4th, 2010 04:42 PM
by John Go to last post
3 98
First column of range in VLOOKUP contains formula by Pluggie
I have two sheets. Sheet 1 has two columns: 1. Code_Descr (example value: "12345_cookies") 2. Attribute_ID (empty) Sheet 2 has 4 columns: 1. Code (example...
February 4th, 2010 04:41 PM
by Pluggie Go to last post
2 81
Lookup by Joe
The setup of the spreadsheet is as follows: Column A: Item Number, Column B: Quantity, Column C: Price I want to create a spreadsheet to lookup values in a...
February 4th, 2010 04:36 PM
by Joe Go to last post
0 60
Statistical functions on non-consequtive columns by Frode
Hi, I have several data tables, where every second column is an index and the other columns uses the index to fetch the corresponding data. If any data is...
February 4th, 2010 04:26 PM
by Frode Go to last post
7 82
percentages by Mich
I need the formula to give me the percentage between 2 numbers - i.e. increase or decrease of 20%. Thanks.
February 4th, 2010 04:19 PM
by Gareth_Evans (InterCall EMEA)[_2_] Go to last post
2 64
Percentage format by dpal
I have this workbook that was working fine. Now every new and old cell changes everything to a percentage. Even if I make a new sheet in that workbook. ex....
February 4th, 2010 03:14 PM
by FSt1 Go to last post
1 91
How do you extract day/time/month/year information by SV
Hello, I came across this issue, where I have a exported excel file. With the information in a field "Friday 02:15:00 March 2009". I need these...
February 4th, 2010 03:10 PM
by SV Go to last post
7 80
Could someone please help me with a solution to my problem? by Eamon
Could someone please help me with a solution to my problem...? In column X I have finishing position last run In column Y I have finishing position...
February 4th, 2010 02:36 PM
by Eamon Go to last post
3 74
How do i stop functions? by 2Lipps
i am using an excel sheet and there are numerals in a column. But they are not to be added together at the bottom of the column. Unfortunately i'm getting...
February 4th, 2010 01:14 PM
by David Biddulph Go to last post
3 88
look up by nader
hi i have sheet1: A B benz 123 jeep 456 fiat 789 benz ...
February 4th, 2010 10:10 AM
by Jacob Skaria Go to last post
2 95
Autofilter by JPDS
I have a large spreadsheet (3000 rows) with staff data which contains details of which directorate, department and team they work in. The spreadsheet feeds...
February 4th, 2010 09:35 AM
by JPDS Go to last post
0 68
Post New Thread


Display Options
Showing threads 3261 to 3280 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:30 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.