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
Alternative to using 10 V-lookup formulas by Tami
I have table with sales data. The user types in the classes they want to sum....they can type up to 10 classes. How can I avoid having to write a formula to...
April 16th, 2009 10:00 PM
by T. Valko Go to last post
3 64
How do I recalculate cell only if reference cell value changes? by murph
I have turned on the iterations (set to 1) for circular values. here is the scenario: I want to keep a runnng total of $$ used I have a cummulative total cell...
April 16th, 2009 09:52 PM
by murph Go to last post
4 52
Copying a cell ref. down a column, changing worksheet # along the by olivia
I am referencing the same cell from multiple worksheets onto a "summary" worksheet. for example, A1='sheet 1'!$B$1 then I want to copy and paste down the...
April 16th, 2009 09:51 PM
by 2traksDavid Go to last post
5 97
Text into Columns by tcmh
For some reason I cannot accomplish this function - I use the menu drop down Text to Columns, I choose Delimited, Next, comma (although there are spaces at...
April 16th, 2009 09:50 PM
by Dave Peterson Go to last post
3 90
combining data from multiple workbooks by dslocum
I have put together a spreadsheet for our customer service department to track the TYPES of support phone calls they receive. Each customer rep has their own...
April 16th, 2009 09:47 PM
by Dave Peterson Go to last post
6 96
"IF" function returns function instead of result by ckrogers
Hi. I have a simple '=IF(K7="LF",L7," ")' function in my workbook to display the value in cell L7 if the Logical Test is "TRUE", otherwise leave the cell...
April 16th, 2009 09:24 PM
by Jarek Kujawa[_3_] Go to last post
6 47
IF function returns function statement rather than result by ckrogers
Hi. I have a simple "IF" statement in my Excel workbook
April 16th, 2009 09:21 PM
by ckrogers Go to last post
3 64
COUNTING by Connie Martin
I have research Help and online. I've done a pile of reading and experimenting, but nothing works. I know it's got to be simple, but finding the answer...
April 16th, 2009 09:11 PM
by Bob Umlas[_3_] Go to last post
4 97
Can't save Excel spreadsheets by Claire
I have spreadsheets on an external drive (GS Drive L:). I access the info on this "thumbdrive" on two computers, one desktop and one laptop. If I try to...
April 16th, 2009 08:36 PM
by Kassie Go to last post
1 71
Help with VLOOKUP & MATCH formula by GoBucks
I am looking for help with creating a lookup formula with multiple conditions. In Sheet1 I have the following table with B2:E2 being the header...
April 16th, 2009 08:31 PM
by GoBucks Go to last post
5 105
EXCEL PASTE DOES NOT CHANGE DATA - PASTE DOESN'T WORK! by robin l
trying to paste dates & other data from one spreadsheet to another and the dates will not change. so although i copy & paste the date - it is not pasting my...
April 16th, 2009 07:56 PM
by Pecoflyer[_292_] Go to last post
7 122
Current Cell location by HRHRLBS
I am trying to use an OFFSET lookup command but need to tell the formula the current location within the column. What formula displays my current cell...
April 16th, 2009 07:38 PM
by Mike H Go to last post
1 63
Percentage over a date range by CP
In row 1 I have Jan to Dec - a header row in row 2 I have a value directly under each date cell - the amount per month in row 3 I need the percentage value of...
April 16th, 2009 05:46 PM
by Eduardo Go to last post
3 66
CANT INSERT CELLS, ONLY ROWS & COLUMNS by robin l
Hi - in one of my spreadsheets, I cannot insert cells, only rows, colums. Any advise?
April 16th, 2009 05:43 PM
by Jacob Skaria Go to last post
1 62
Is there a Conditional Sum Wizard in Office 07? If so Where by Brian86
Yea, I'm lazy. I just want to be able to conditionally sum as quickly as possible
April 16th, 2009 05:39 PM
by T. Valko Go to last post
2 51
data in 2nd column associated with =MAX(H1:H100) from another colu by tcek
I have two columns. Column one has the dates of the month and the second column has inventory amounts for that date. The inventory amounts is paste linked...
April 16th, 2009 05:33 PM
by Mike H Go to last post
2 97
Highlighting the entire row with conditional formatting by Allen
Hello, I am using the True/False condition to highlight an entire row through conditional formatting but the highlighting stops where there is a zero in a...
(Multi-page thread 1 2)
April 16th, 2009 05:09 PM
by T. Valko Go to last post
11 118
data associated with latest date by tcek
I have two columns. Column one has the dates of the month and the second column has inventory amounts for that date. The inventory amounts is paste linked...
April 16th, 2009 05:07 PM
by tcek Go to last post
5 86
Macro for detect palindromes and repeats in letters/numbers string by Luciano Paulino da Silva
Dear all, I am looking to detect palindromes (sentence or number or other sequence of units that can be read the same way in either direction) and repeats...
(Multi-page thread 1 2 3 ... Last Page)
April 16th, 2009 04:59 PM
by Luciano Paulino da Silva Go to last post
33 303
How to count/tally entries? by chrisk
Hi I want to put a number by a name for each job a staff member...
April 16th, 2009 04:41 PM
by chrisk Go to last post
2 73
Post New Thread


Display Options
Showing threads 12061 to 12080 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:56 PM.


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