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
Saving workspaces (.xlw) Get error message by KatCook
Suddenly, I can no longer save my workspaces in 2007. The error message says I must choose another extension, but .xlw is the only one I know.
July 17th, 2009 06:13 AM
by Jacob Skaria Go to last post
1 97
Can I format one cell so that it affects another cell? by David
Cells A1 (feet) and B1 (meters) are formatted with data validation so that only specific values can be entered in those cells. Can I format A1 so that if I...
July 17th, 2009 02:52 AM
by David Go to last post
4 123
July 17th, 2009 12:18 AM
by calduke Go to last post
2 93
Conditional Formatting and cloring cells and date calculations by John
I want to calculate time passed by subtracting one date from another and put the time in hours and minutes in a cell. If the value in the cell is greater...
July 16th, 2009 11:05 PM
by Rajesh Mehmi Go to last post
1 110
conditional format of entire row based on a single cell in row by CEG_Staffer[_2_]
I have a worksheet with data in cols A - L. I would like to conditionally format each row based on wheter (or not) text is in the cell of col D. If text is...
July 16th, 2009 10:54 PM
by Rajesh Mehmi Go to last post
7 152
--(a1:a4) by dcstoo
What does the syntax in the subject denote? What is the purpose of "--" (double dash)?
July 16th, 2009 10:10 PM
by Dave Peterson Go to last post
1 75
How do I make worksheet into fillable form? by Tiana Herrera
I have a project for work that I am doing and I need to know just how to make the worksheet I have into a fillable form. If anyone might know please give me...
July 16th, 2009 10:07 PM
by Dave Peterson Go to last post
1 196
jpg pictures in cells by lehigh46
Hi all, Is it possible to paste pictures in cells? Not on top of cells but within the limiting edges of a cell? If so, could a formula place in a cell lookup...
July 16th, 2009 09:52 PM
by Paul C Go to last post
1 135
VLOOKUP with two sheets by C Kreig[_2_]
I have two worksheets with thousands of items. I want to ID which assets were added in 3.2.09 but are now gone 7.1.09. Only serialized items are of...
July 16th, 2009 09:37 PM
by Per Jessen Go to last post
2 88
Vlook-up in report with column Expansion by Ken Mock[_2_]
Looking for a way to vary the returned value column in a Vlook-up function. I have a report that can be run for a various #of financial periods the Value...
July 16th, 2009 09:07 PM
by T. Valko Go to last post
5 100
sum if with an and by Marlaine
I have 3 columns of data, A contains the type, B contains the quarter and C contains the value to add. I was to add up all the "Any" types in "Q1!. I...
July 16th, 2009 09:05 PM
by Per Jessen Go to last post
2 108
SORTING WORKSHEET TABS by Tree
I need help with the VB project listed on Pearson's webpage for sorting and ordering tabs within a worksheeet. I tried to follow the directions given for...
July 16th, 2009 08:56 PM
by Tree Go to last post
1 106
If any cell in a range has a value, return "True" by raystub
I am looking for a formula that, if any cell in a range has a value, will return "True", and if all blank, return "False". Thank you.
July 16th, 2009 08:37 PM
by Lars-Åke Aspelin[_2_] Go to last post
1 68
Recover columns in a worksheet by cjennings
A column was hidden minimizing with mouse rather than using the Format/Hide Column method. I'm lookimg for suggestions on how to recover the column. I...
July 16th, 2009 08:09 PM
by libby Go to last post
1 74
If, then, vlookup by akemeny
Ok... so I've tried doing this every which way I can think of. I have multiple spreadsheets that I need to have looked at to verify that the account numbers...
July 16th, 2009 07:50 PM
by Squeaky Go to last post
1 85
Calculating 10 Business Days from the Last Business Day of the Mon by Jeff H
OK, I am drawing a complete blank on this one. I'm having a total brain glitch. Is this a sign that maybe I need to step away for a minute? (Maybe.) I need...
July 16th, 2009 07:32 PM
by Ron Rosenfeld Go to last post
5 87
I need help creating a score sheet with weighted values. Help Plea by Erin
I am trying to creat a simple worksheet with 7 columns to score employees in a performance review. Each column has to be scored on a 1-5 point range, while...
July 16th, 2009 07:28 PM
by Erin Go to last post
2 92
Data Validation-pick from dropdown and next cell auto fills in inf by sunsetsweete
I am trying to set up a spreadsheet where when I pick an option from the drop down, the next cells auto fill in the info for the next few cells based on what...
July 16th, 2009 07:06 PM
by T. Valko Go to last post
1 76
SUMPRODUCT with Date Range by LouD
Hello, I have been searching this forum all day and I can't seem to get any code that I find to work. Below is what I believe should work. Cell D349 has...
July 16th, 2009 07:04 PM
by LouD Go to last post
4 84
Sumproduct formula not working by Vince
The following formula returns...
July 16th, 2009 07:01 PM
by Don Guillett Go to last post
7 109
Post New Thread


Display Options
Showing threads 9061 to 9080 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 08:32 AM.


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