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
EXCEL 2007 - INSERT NEW WORKSHEET by robzrob
How do I get one? I'm d*****d if I can find the way! Why do they have to change everything?!?!?
April 19th, 2009 07:44 PM
by robzrob Go to last post
4 84
Naming Cells Using Relative Cell References by Inobugs
Can a cell be named so that when the sheet is sorted, the name refers to the same data even though the position of the cell has changed?. I tried naming...
April 19th, 2009 03:50 PM
by Chip Pearson Go to last post
1 76
On error by Kashyap
Hi, I have code as below which will update links.. On error sheet will be unlocked.. how to lock the sheet again and exit sub? Sub...
April 19th, 2009 02:28 PM
by Kashyap Go to last post
3 88
I want to undo 'move or copy worksheet' by Virginia
I have spent all morning filling in an Excel sheet with a lot of data, then moved or copied the worksheet so that I could massage the information without...
April 19th, 2009 05:02 AM
by Mr. Haney Go to last post
1 106
loan to value function? by KenWagnerRealtor
Hi, I'm a bit rusty on excel functions. 1st Loan $ is AR1 2nd Loan $ is AS1 Sale Value is AE1 and mathematically LTV = (1st+2nd)/Sale in a percentage format.
April 19th, 2009 02:59 AM
by KenWagnerRealtor Go to last post
4 140
Capturing Top 5 Performers by Questor
I'm using the LARGE function to find the top five values (number) in column "F" of a large list and place those values in Cells N1 thru N5 — Cell...
April 18th, 2009 11:33 PM
by Chip Pearson Go to last post
5 151
sort source data sheet while destination shows same data by Inobugs
Is there a way to link information from an Excel spreadsheet in a source workbook to a second (destination) workbook, sort the source workbook, and...
April 18th, 2009 09:36 PM
by ryguy7272 Go to last post
1 101
PASTE DOESNT WORK by robin l
Can I send someone my spreadsheet - pasting from one spreadsheet to another is not working. Dates and other data do not paste correctly and all my data...
April 18th, 2009 06:27 PM
by Ken Wright Go to last post
9 107
need Excel cell to show value, not formula by jori
I have Excel 2003. I've entered concatenation formula, which is calculating correctly, but the cell itself shows the formula, instead of the result. The...
April 18th, 2009 05:47 PM
by jczerlonka Go to last post
4 89
SumIf or SumIfs or something else? by crmccurry
I have a worksheet with a list of names like this A Staff Joe Suzie Sally Sam And another worksheet that has a pivot table of data that I need to sum
April 18th, 2009 05:46 PM
by Herbert Seidenberg Go to last post
2 113
Vlookup Cell Format by Richard
Can vlookup or any other function bring over the cell formatting?
April 18th, 2009 05:17 PM
by Dave Peterson Go to last post
3 90
how we find specific word from string in excel and compaire it. by Vishnu
i have three fields like Date description amount 1/2/9 Mobile bill 45 25/2/9 Lycatel (mobile) 5 27/2//9 Shopping...
April 18th, 2009 07:51 AM
by Jacob Skaria Go to last post
2 93
formula help by Araseli
hello, I have A B C B E 1 c 100 90 c 2 c 100 100 b 3 d 200 80 f 4 d 100 90 d total I need a...
April 18th, 2009 07:21 AM
by JBeaucaire[_92_] Go to last post
5 90
Worksheets by George Mcfly
I have an excel file with 5 worksheets saved. Computer was cleaned of viruses. Now when I open the file only one worksheet comes up and no tabs to click on...
April 18th, 2009 03:14 AM
by Teethless mama Go to last post
2 102
Help with data total by Marlin2412
I am trying to find out how I can create a form that will add up how many times a certain letter combination appears in a row of data. To help clarify, I am...
April 18th, 2009 02:35 AM
by Teethless mama Go to last post
3 86
Split text file into Excel sheet and separate the final results intoa new sheet by Luciano Paulino da Silva
Dear All, I would like to split one text file (example bellow) containing several packs of data with the head "MW-....." into one excel file for which each...
April 18th, 2009 02:00 AM
by Luciano Paulino da Silva Go to last post
8 282
Excel 2007 - toolbar for Text to speech by Sandeep
In MS office 2005, there was toolbar for the checking of the data by using the text to speech toolbar. Can Anyone guide me where the same is located in...
April 18th, 2009 01:43 AM
by M. Stein Go to last post
3 135
Multi column sumproduct by Todd
I think the sumproduct is the correct formula but I can't get this right. I am trying to get a total amount of parts though multiple issues as shown...
April 18th, 2009 12:42 AM
by Teethless mama Go to last post
4 86
Constant in Excel Formula by Chele
I remember using the $ i think to keep a column constant when doing a formula. What is it?
April 18th, 2009 12:34 AM
by Ashish Mathur[_2_] Go to last post
3 150
need sumproduct to return text values... by jat
this is a follow up to my previously posted subject line: "vlookup (indirect, or sumproduct) using three tabs" i have a sumproduct working (sort of, but not...
April 18th, 2009 12:07 AM
by jat Go to last post
2 104
Post New Thread


Display Options
Showing threads 12001 to 12020 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 11:56 AM.


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