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
How do I convert word data (not in tables) into excel format? by resret29
I have MS Word/Excel 2003 and a 250 page document extracted from a proprietary software system with numerous fields. Unforunately, when I open it in Word or...
October 9th, 2005 01:25 AM
by David McRitchie Go to last post
2 134
October 9th, 2005 02:14 AM
by David McRitchie Go to last post
2 167
October 9th, 2005 02:16 AM
by David McRitchie Go to last post
1 234
IFSum(Vlookup... by J Shrimps, Jr.
Need to divide a value in a column by a set of running sum values in an adjacent column. Data looks like this: Product Month Bal RemBal ...
October 9th, 2005 02:52 AM
by Biff Go to last post
7 185
create a conditional formula by Matt H.
Trying to create a formula that when depending on what word is selected from a list I created, then another list will appear in that cell
October 9th, 2005 03:57 AM
by Max Go to last post
1 181
October 9th, 2005 03:58 AM
by Alex Go to last post
5 153
calculator Errors by Kat and the Calculator
When I enter an equation in c1 such as: =product(a1,b1), when a1 is 1000 and b1 is .10, the answer in c1 should be 100, but it comes out to 102.04. ...
October 9th, 2005 04:13 AM
by Kat and the Calculator Go to last post
3 91
How do I hide the zero in the "sum" cell until numbers are put in the cells that are being added? by Radman
I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0" on the spreadsheet if nothing is inputed into any of the 3 other cells. How do i write...
October 9th, 2005 04:25 AM
by Ashish Mathur Go to last post
6 233
Calculation on SUMIF Results by Andy B
Hi all, I have a bit of a proble, I want to perform a rate calculation on the results of a sumif i.e. Customer Currency Rate value 1 USD ...
October 9th, 2005 04:47 AM
by Ashish Mathur Go to last post
3 107
formatting problem with functions by Robin M.
I have attempted to use the PROPER function in an adjacent column to my data. I entered =proper(e1) and the cell only display the function not the result. Help!
October 9th, 2005 04:49 AM
by Robin M. Go to last post
4 168
2 Columns - Show extra items in Column B by orbojeff
I have 2 Columns A & B Column B contains all of the data in Column A and then some. I need a function that will show all of the extra items in Column B.
October 9th, 2005 04:51 AM
by Ashish Mathur Go to last post
4 113
Lotto Number Checker by clash
clash Wrote: Please help. I have to check 30 Lotto tickets ever week and have tried (and failed) to come up with a way over putting all the selected...
October 9th, 2005 04:53 AM
by Zdzislaw via OfficeKB.com Go to last post
2 138
How NOT to extend formula/refrence to a cell by [email protected]
Hi One of the cells( of sheet2) of my excel has formula as =Sheet1!C2 I want the next (say 30 ) cells to have the same formula =Sheet1!C2. I dont want excel...
October 9th, 2005 10:02 AM
by Pankaj Go to last post
2 123
Unary + Operator by xcelion
Hi , Can anyone tell me what is the use of unary operator + in formulas(like =+B4) .What does it mean? . Thanks in advance Xcelion
October 9th, 2005 10:58 AM
by Ken Wright Go to last post
5 211
Friends: Please guide me by PRASAD RAO SEERA
Dear Friends, I need a small information. Recently, I appeared for Financail Executive post in a leading private bank. And, in that interview, I am asked to...
October 9th, 2005 11:06 AM
by Ken Wright Go to last post
7 151
macro to compare multiple cells to determine value by macrodummy
I need help building a macro that would take the # of hours worked and compare it to the list below to determine cost of for Ind and Family. # of...
October 9th, 2005 01:21 PM
by macrodummy Go to last post
2 102
I need a conditional formula by ltracy
I am creating a master budget. I have worksheets and the first is my input page. On one of the pages I have situation where if I have a large amount left in my...
October 9th, 2005 03:05 PM
by Bob Phillips Go to last post
2 84
Sum with 2 criteria by Dave
I want to setup monthly summary sheets that uses data from another page i have a formula that works however to make it work i have to select cells on the ther...
October 9th, 2005 03:07 PM
by Bob Phillips Go to last post
2 106
How to get pointer in new cell on Open? by Jazz Drummer
I want to have the pointer in the next new cell each time I open the workbook. is there a way to do this? Thanks
October 9th, 2005 03:13 PM
by Jazz Drummer Go to last post
2 105
Cant get totals to work with IF statements by spelingchampeon
I have a situation where I want cells to total up each week. I'll try to set it up as best as possible: For my explaination, I will use 1 of 4 people...
October 9th, 2005 03:14 PM
by spelingchampeon Go to last post
4 136
Post New Thread


Display Options
Showing threads 20001 to 20020 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:24 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.