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
Functions on filtered data by LiAD
Afternoon, I have an excel sheet of 10 cols and 200 rows on sheet 1. Sheet 2 has a table which searches through the list of data in sheet 1 to 1 - produce a...
March 26th, 2010 03:06 AM
by Ashish Mathur[_2_] Go to last post
1 127
reference cell from advanced filter by Nathan
I'm sure this is slam dunk, but I can't figure it out :) On worksheet 1, I have executed an Advanced filter of 900 rows, to get down to one row. No...
March 26th, 2010 03:02 AM
by Ashish Mathur[_2_] Go to last post
3 157
First Day of the month by Jen_T
Does anyone know how to have excel look at a cell that has a date that is formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as...
March 26th, 2010 02:59 AM
by Ashish Mathur[_2_] Go to last post
3 145
convert vertical to horizontal by Mona
I see lots of post but not one I can use. I am looking for a "function" that will take vertical data to horizontal. I don't want the copy,paste, transpose...
March 26th, 2010 02:48 AM
by Ashish Mathur[_2_] Go to last post
6 175
sorting data by Hellomoto
I have a column of data that repeats every 10 rows. that is, the data type is repeated every ten rows. I want to reorganize the data in that column into 10...
March 26th, 2010 02:46 AM
by Ashish Mathur[_2_] Go to last post
2 138
excel dates by king2385
how do i change #(1-365) to the corresponding date in excel?
March 26th, 2010 01:49 AM
by Fred Smith[_4_] Go to last post
1 131
Collecting data from Excel form by Ricki Miles
I am working in Excel 2003 and would like to know if there is a way to create a form for data fill-in so that the data would then be collected in a database...
March 26th, 2010 01:48 AM
by Ricki Miles Go to last post
2 174
Formula Question by Tony
Was wondering if there is an IFcount formula for this scenario? Below on Sheet 1 A B C 1 125 58 183 2 896 876 20 3 500 11 511 4 244 5 249
March 25th, 2010 10:36 PM
by Tony Go to last post
4 213
Complicated IF statement - desperately need some help by Mark D
Afternoon everyone. Have been struggling to get a formula together for the following. I am being told due to its complexity that I will probably need to...
March 25th, 2010 10:34 PM
by Ziggy Go to last post
4 188
Sumproduct with Multiple Criteria by JeffTO[_2_]
Hi All I have a question which I cant figure out - I use Sumproduct alot to sum up multiple criteria and it works well in most situations I have no problem...
March 25th, 2010 10:31 PM
by T. Valko Go to last post
2 133
data not carrying over from access to excel by JoeM
When I am running a query in MSAccess 2007 I get 1315 records, when I run the query via Excel 2007 connecting to the DB it stops at 691 records. I'm a little...
March 25th, 2010 10:03 PM
by JoeM Go to last post
0 111
testing range of cells for part of cell content by Daniel
Hi, I'm new to advanced excel formulas so please bear with me. So I'm trying to make a formula that sums only certain values in a range of cells. The problem...
March 25th, 2010 09:14 PM
by T. Valko Go to last post
5 179
Removing ''VALUES'' by Mark D
Hi Again (where would I be without the help from this board) I have a forumula in a cell as follows =IF(ISNA(VLOOKUP($A77,'Personal NFI...
March 25th, 2010 09:13 PM
by Ziggy Go to last post
5 142
Use vlookup within offset? by berniean
Can I use a vlookup within an offset formula to define the reference? I want to find a value in a column on a tab, go down one, and record the anwser. On...
March 25th, 2010 08:49 PM
by T. Valko Go to last post
4 143
SUMPRODUCT multiple criteria (with a twist) by GD
How do I use SUMPRODUCT if one of the criteria arrays is the same as the totals array. I want to total all cells in column L that have a 1 in column D, as...
(Multi-page thread 1 2)
March 25th, 2010 08:39 PM
by Ranjith Rajaratnam Go to last post
13 308
adding result of "if" statement.. by Xiamen
I have created this "if" statement. =IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0", IF(G17=(166718),"1", IF(G17=(166685),"4",...
March 25th, 2010 08:23 PM
by Ziggy Go to last post
3 135
Last number in a column shows in the total/summay line cell by Jen S[_2_]
I am looking for a formula that would have the last number listed in a column listed in the total or summary row of the spreadsheet. Column A lists the...
March 25th, 2010 08:13 PM
by Ziggy Go to last post
3 113
Combining data by nitengale
I'm sure there is a formula out there to do this, but I'm not finding any help in the help function in excel. I have one worksheet for each day of the month...
March 25th, 2010 07:57 PM
by Eduardo Go to last post
1 169
Filling formulas with specific cell references remaining the same by quinxorin
I need to fill a formula in a range of cells downward, specifically the formula IF(OR(O2=U1,P2=U1,Q2=U1),2-L2,0), with the U1 cell references remaining the...
March 25th, 2010 07:56 PM
by quinxorin Go to last post
2 102
Excel data from spreadsheet to database by Ricki Miles
Can anyone please direct me to an article that has instructions on how to gather data from an Excel 2003 spreadsheet into a separate database? Thank...
March 25th, 2010 07:47 PM
by Gord Dibben Go to last post
1 130
Post New Thread


Display Options
Showing threads 1801 to 1820 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 04:17 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.