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
countif using other cell values for 'range' and 'criteria' by tony
using excel 2007 I am trying to set up a countif function that can easily be used by basic excel users. what i want to do is have a couple of cells where the...
January 8th, 2010 02:18 PM
by Bob Phillips[_3_] Go to last post
4 142
Help with colour formula by bill gras
In column W row 2 I have a formula eg: =IF(AND(L2=5,V2=7.1),V2,"") copied down to row 1001 not every row has a result , lots of rows are blank . The...
January 8th, 2010 12:31 PM
by RonaldoOneNil Go to last post
3 97
Inserting symbol by judyl
I'm trying to insert a symbol next to a number in a cell that is totaled. When I attempt this the number is not then recognized for the correct total. Do I...
January 8th, 2010 11:11 AM
by Mike H Go to last post
6 90
lookup over several columns by Sander Nagtegaal
I'm trying to have a lookup over several columns situation sheet 1 A B C 56 110 50000 56 120 10000 56 130 5000 57 110 30000 57 ...
January 8th, 2010 09:12 AM
by Sander Nagtegaal Go to last post
2 141
Check Box Question by Ksean
How do I achieve the following? If cell D10 has anything of any value in it I would like cell D5 to display a result of ‘X’ however if cell D10 is blank...
January 8th, 2010 03:25 AM
by T. Valko Go to last post
5 141
How can I automatically color a row based on cell content by Ed
I'd like to automatically color code an entire row of a spreadsheet I'm creating based on the entry of a single cell. The cells with the entries are all in...
January 8th, 2010 02:06 AM
by Gord Dibben Go to last post
1 109
Excel - IF formula with range of cells by Chris
I am trying to create a formula that if a range of cells contains a specific value AND a range of cells in the next column contains a specific value, then...
January 8th, 2010 01:24 AM
by ryguy7272 Go to last post
2 98
I want to copy the same image into worksheet with a function by Garry
I wish to use a function on a worksheet to copy and image from another worksheet in the same workbook. The function "CopyImage" is listed but no help to...
January 8th, 2010 12:28 AM
by Gord Dibben Go to last post
1 105
contitional formating with more then three options by peterg
How do i do contidional formating in a cell with more then three options? What does the code look like for a vba script? I know it can be applied to the...
January 8th, 2010 12:14 AM
by Gord Dibben Go to last post
8 149
Importing Access DB into Excel changes my calculated fields in Exc by Shadow27_us
I currently have an Excel worksheet that imports data from MSAccess. I have calulated fields built into this Excel sheet that calculates info from the...
January 7th, 2010 11:10 PM
by Eva Go to last post
3 132
Pivot Table (behind the scene) by DHN
Hello MVPs, I need help with a formula that would be able to do the same as a filter in a pivot table. I have two filters that I would like to be able to...
January 7th, 2010 07:59 PM
by Herbert Seidenberg Go to last post
8 145
Auto Calculate Question / HELP! by Andy
When I click on the fill handle to drag the data down the cells fill with data grabbed veritcally, for example: When I drag the fill handle down the formulas...
January 7th, 2010 07:21 PM
by Roger Govier[_3_] Go to last post
2 107
Hide/lock worksheets by McChas
I have a workbook with 10 spreadsheets. Each sheet/tab is for individual employees. Is there a way to have a user sign in and only view their own tab and not...
January 7th, 2010 06:50 PM
by Luke M Go to last post
4 102
New Drop-Down Functionality in 2007? by GregO
I've noticed when working in 2007 that I can reference field names as , which show up as a drop-down menu. As soon as I type =[, a menu pops up with a listing...
January 7th, 2010 06:47 PM
by Roger Govier[_3_] Go to last post
2 133
How can you attach an e-mail into an excel worksheet? by humdul
I want to attach an e-mail into an excel worksheet. The formula I have seen is =EMBED("Package","") But not sure how I can do it. Any ideas?
January 7th, 2010 06:23 PM
by Luke M Go to last post
1 99
calculate date of birth with an end date and age by Tifosa
I have a sheet with a retirement date which will be the x birthday, and the age (x) of the client at that date. I need to get a date of birth for each of...
January 7th, 2010 05:03 PM
by Bernard Liengme Go to last post
1 192
number times a value appears in a column beside it chronological by Papa Cricket
I am looking to count how many times a number appears in a column beside that number as you go down that column. Beside the first occurance of the number 10...
January 7th, 2010 02:58 PM
by Bernard Liengme Go to last post
3 125
Lookup cell for documents in a folder by Marc Trumpi
I am trying to create an overview of the time spent on projects. People hand in weekly time-charts in excel format where the projects are referenced by a...
January 7th, 2010 02:17 PM
by JLatham Go to last post
1 106
convert numbers by ekkeindoha
Good day, I would like to auto change the top number to 5 and descending to the last one to be 2. 2868 5 1800 1800 1200 624 624 576
January 7th, 2010 11:39 AM
by Joe User[_2_] Go to last post
3 92
Timesheet formula problem by Leo
Trying to add two rows of times with the result in one cell, but having trouble. When I try to add the two rows together, I get a “$VALUE” result. ...
January 7th, 2010 10:51 AM
by David Biddulph Go to last post
3 117
Post New Thread


Display Options
Showing threads 4061 to 4080 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 03: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.