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 Reverse Sort Order Last Post Replies Views
can i multipy values in a column by 1 number by davnjessy
I have a column containing currency values. I want to multiply the values by the current exchange rate which i will input on another sheet to give me the new...
December 6th, 2006 09:59 PM
by Gord Dibben Go to last post
3 44
Can I hide a row conditional upon a cell value? by davo1805
I want to create a sheet which will serve as a Proforma Invoice displaying data from a Bill of Materials sheet within the same file. For any line item where...
December 11th, 2008 12:31 AM
by Gord Dibben Go to last post
2 61
"Conditional" sum by davor
Please help. I have "input" data like this: AA BB AA DD CC -------------------------------------------------------------- 8 ...
October 10th, 2007 02:02 PM
by davor Go to last post
3 33
I've used SUMIF for simple calculations such as: SUMIF($F$32:$F$39,"Contracted",$H$32:$H$39) on a single sheet. How would I work that using INDIRECT to...
February 22nd, 2007 07:50 PM
by Sandy Mann Go to last post
4 53
referencing worksheet tabs by davsco
In my file, i have a separate worksheet for each day of the month (1, 2, 3, etc) that has a bunch of lines with a total in (let's say) row 10. In the last...
June 12th, 2008 03:24 AM
by T. Valko Go to last post
1 57
Adding checkmarks to an excel spreadsheet by Davscober
I am trying to set up a chart and instead of using "yes" or "no" for answers, I'd like to be able to use checkmarks. Is that possible?
September 21st, 2009 01:23 AM
by Michael.Tarnowski Go to last post
3 74
Send worksheet Excell via mail by Davy
Hello, is there any function with how i can my send the curent worksheet to a preseverd person - like i make a sheet with a button , when i click the button...
October 8th, 2003 12:36 PM
by Ron de Bruin Go to last post
1 160
How do I turn off ALL autoformat in Excel ? (I can't even type "J. by Davy B.
1. Select all cells by clicking cell in top left corner 2. Right-click 3. Select the option that turns off autoformat. I rock! Dave "Dave a.k.a....
February 23rd, 2005 01:46 AM
by Myrna Larson Go to last post
1 71
Exporting multiple cell contents into word document by Davy L
I have a spreadsheet that contains references to 400 Approx items. I also have a generic word document that I need to input the 400 references into....with me...
September 6th, 2005 04:06 AM
by Blue Hornet Go to last post
1 56
Replace formula with current value by davyb
Hi does anyone know how I can replace a page full of cells with formulas pointing to cells in another workbook with the numerical value of what is currently...
September 1st, 2005 11:23 AM
by NlCO Go to last post
1 54
how can I perform trig. functions usings grads 400deg per circle by davystuff
I am building a spread sheet to calculate the triangles for the setting out stations for various sites and wish to work in grads i.e. 400degrees per circle...
March 30th, 2006 03:00 PM
by Bernard Liengme Go to last post
2 62
how do i change a formula to its value by Davy[_2_]
After a range has calculated the answer from a formula, how can I change the same range to the value displayed?
July 10th, 2007 07:22 PM
by Teethless mama Go to last post
2 42
Conversion Formula by Dawg
Iā€™m looking for a formula to convert distance. Example: 60.625 to 5ā€™ 3/8ā€ Is this possible? Can someone help me?
November 11th, 2006 11:00 PM
by Biff Go to last post
3 39
Nested Ifs & NetworkDays Combined Functions by Dawg House Inc
OK...I've tried consulting many boards to get around the nested if limit in Excel 2003. I remember seeing something about concatenating strings together, but...
October 16th, 2008 06:17 AM
by ShaneDevenshire Go to last post
4 51
Ratio - How To Create Your Own Function/Formula by Dawg House Inc
Well, after hunting on here for suggestions for how to create my own ratio formula, I ended up (through trial and error and testing) manufacturing my own...
February 14th, 2007 12:40 AM
by Dawg House Inc Go to last post
2 46
How Do I Do an Exclude Filter based on a Named Range? by Dawg House Inc
I have a 450 record listing that has five columns in it, of which, column C is "Location". I also have a named range in Column J called "ClosedLocations". I...
April 11th, 2006 02:49 AM
by Max Go to last post
8 84
Function to Return another Worksheets Name by Dawg House Inc
Is there a way I can, in the first worksheet of 40, type in a cell a function that will return me the name of another worksheet? I know how to return...
March 22nd, 2005 07:10 PM
by Arvi Laanemets Go to last post
7 75
VLOOKUP - columnar sheet with multiple matches - need to return a by dawgfan
I have a huge spreadhset (and a deadline!) that VLOOKUP will find several matches for the lookup_value. Each may have a diferent value at the range_lookup. I...
October 9th, 2009 02:09 AM
by FatBytestard Go to last post
7 60
Web Query (Excel 2003) by Dawgman
I'm trying to create a workbook that queries financial data (multiple tables) from MSN. I can get the data queried just fine into different worksheets, but I...
June 18th, 2006 04:58 PM
by Dawgman Go to last post
3 95
Can I calculate the number of days taken off in a running period by dawh
I'm trying to work out how to calculate the number of days a person has taken off in a running twelve month period. For example if a person had been off 2...
June 7th, 2007 11:51 AM
by Pete_UK Go to last post
1 43
Post New Thread

Display Options
Showing threads 20161 to 20180 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:07 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004-2020 OfficeFrustration.
The comments are property of their posters.