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
question related to Data Vaildation by Dharmesh[_2_]
Dear all, I have two columns. Each column contains a defined value and each value carries some predefined details. I am trying to place a dropdown through...
May 18th, 2010 03:14 AM
by Ms-Exl-Learner Go to last post
4 192
SUMIF using value from MOD function by Steve Vincent
Hello, I want to conditionally average a range of cells that are formatted in elapsed time (e.g., 1:03 hrs/min ) but that actually contain a function (...
May 18th, 2010 01:11 AM
by T. Valko Go to last post
2 161
How do I use advance filter correctly? by David
Good afternoon, I have a list of numbers (it's actually very long but for simplicity lets say it's not). The list is in column A and is 1-10 (A1=1, A2=2,...
May 18th, 2010 12:47 AM
by Ashish Mathur[_2_] Go to last post
2 208
V Lookup and Multiple Values by owl
Hello, I am looking to figure out how to use V Lookup with multiple values. I have about 30 of the same name in column A (This is picked out of about 30.000...
May 18th, 2010 12:46 AM
by Ashish Mathur[_2_] Go to last post
2 222
Auto updating muiltiple spreadsheets in Excel 2007 by iBob
I have 50 spreadsheets which calculate aging on past due invoices. I use the =now and =today functions to determine which accounts are past due. I created a...
May 17th, 2010 10:23 PM
by Ron de Bruin Go to last post
1 221
Why does forumula show in cell instead of formula result? by Ashley
Sometimes when I enter a formula into an Excel cell, the formula itself is displayed in the cell instead of the formula result. However, when I open Formula...
May 17th, 2010 09:45 PM
by Dave Peterson[_2_] Go to last post
2 138
How can i invert the selection of cells in Microsoft Excel 2007 by heya
Like i select A1, then all other cells are selected except A1.
May 17th, 2010 09:40 PM
by Marc Gagnon Go to last post
2 181
How do I calculate the 3 sigma of a number? by OGWONE
The number I'm working with is 1.67E6, and I need the 1st and 3rd sigma points.
May 17th, 2010 09:23 PM
by David Biddulph Go to last post
1 161
Linking multiple databases to one summary page by BK
For a manufacturing report, I currently have each area of production logging work orders into a database. Each of these databases (8 in total) link to three...
May 17th, 2010 08:40 PM
by BK Go to last post
0 172
Excel Doc by Carmelbeetle13
Hello, I have a work phone list that I created in excel and have posted on our share drive. What I would like to do is let everyone in the department have...
May 17th, 2010 08:21 PM
by Carmelbeetle13 Go to last post
0 172
Linking sheets which must update the date first. by iBob
I have 50 clients, each with an Accounts Recievable worksheet. Past due is determined by using the =now and =today functions. This information is then linked...
May 17th, 2010 07:26 PM
by iBob Go to last post
0 184
count number of columns based on values across a row by r2rcode
i need to calcuate the number of columns that have a value greater than zero within a particular row.
May 17th, 2010 06:54 PM
by Luke M[_4_] Go to last post
1 197
Need help with if function by Donna
Sorry if this is a double post. I don't see my first one. Need help with the if function. If cell K84 says Peds, I need N84 to say Peds. If cell K84 says...
May 17th, 2010 06:22 PM
by Donna Go to last post
0 143
Can you hyperlink to a hyperlink? by dalguypm
I'm am having trouble linking/referencing a cell that contains another hyperlink. There is a master list on one tab, that has hyperlinks to all documents...
May 17th, 2010 06:18 PM
by Don Guillett[_2_] Go to last post
1 137
Need help with if function by Donna
Hello all. Need help with the if function. If cell K84 says Peds, I need N84 to say Peds. If cell K84 says Psy, I need N84 to say Psy. If K84 has any...
May 17th, 2010 06:18 PM
by Luke M[_4_] Go to last post
2 121
Looping Format by Totoshi
Hi everyone, I need some help a looping format, here is the problem: I have data in col A B C , and i need each time both A1 B1 C1 is equal to zero the text...
May 17th, 2010 06:07 PM
by Totoshi Go to last post
3 131
count the number of rows with entries greater than zero by r2rcode
i need a formula that will look at the information in a range of column within a row. if the number in a column is greater than zero, then i need to add one...
May 17th, 2010 05:35 PM
by Luke M[_4_] Go to last post
1 158
excel by dobbers
I have a spreadsheet linked to others which retrieves data from each month and places the infor in a sumarry table. Rather than change the formulas each...
May 17th, 2010 01:59 PM
by Luke M[_4_] Go to last post
1 119
circular formula gives different values by jolly
I have a circular reference in my worksheet where I get two sets of values for the same input as the circular flips between two values. I have set the...
May 17th, 2010 01:47 PM
by Luke M[_4_] Go to last post
1 118
Find a number in a column then return a value from another cell by Mark Dullingham
I have the follow data laid outs as follows; E F G H 1 No. Descr Ref Layout 2 1 Name1 1,2 ...
May 17th, 2010 09:57 AM
by Mark Dullingham Go to last post
2 161
Post New Thread


Display Options
Showing threads 501 to 520 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:16 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.