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
Search Macro by Eán[_2_]
Is there a macro of function I can use to find key words or statements on a worksheet, similat to the Find (goggles) icon? Many thanks.
April 21st, 2010 02:51 PM
by Jacob Skaria Go to last post
3 94
Formula Excel by Newfie809
Wondering if someone would be able to help me with this: A B C Year Year Service 01-Sep-89 30-Jun-10 = 21 Years Teachers From September 1, 1989 to...
April 21st, 2010 02:16 PM
by Newfie809 Go to last post
2 114
Help with Date Function by mdj0615
I have tried, and I can't figure out if this is possible. I'm trying to have dates autofill into a row of columns (C5 to V5 to be specific). I don't want...
April 21st, 2010 02:00 PM
by Duke Carey Go to last post
2 123
Count values in array of data where no blanks in one column by CW
Hi, I am collating project details from multiple sources and need to report back how many projects are active in specific phases based on data such as in the...
April 21st, 2010 12:43 PM
by CW Go to last post
4 167
Range Vlookup by deen
Hi Every One, I hope you all are doing well, I required your help to resolve my issue in excel. On single worksheet i have two different sheet name as 1.IP...
April 21st, 2010 12:32 PM
by Jacob Skaria Go to last post
1 124
Automatic update to SUM formula cell references. by David S
I have a spreadsheet that has many SUM formulas that change on a monthly basis. Instead of manually changing each formula every month I want to create a...
April 21st, 2010 12:21 PM
by Ashish Mathur[_2_] Go to last post
6 146
How to hide infromation in Excel? by Sarah
I am trying to hide information in Excel. I hid the row I wanted to hide. I can see hidden row when copy and paste information in new excel file. Is there a...
April 21st, 2010 12:01 PM
by Ashish Mathur[_2_] Go to last post
3 137
multiply value based on quantity by Bigfoot3910
I am trying to calculate a discount price based on quantity purchased. For example if someone buys 20 widgets they pay $4.00 each for them, if they buy 50...
April 21st, 2010 12:00 PM
by Ron Rosenfeld Go to last post
3 126
Return cell characters after space by Andy
I have a cell with 'Mr J. Smith' and want to return in another cell 'Smith'. As there are many other examples, I need a function that will seek out the last...
April 21st, 2010 10:25 AM
by Andy Go to last post
2 172
Count If.....help by Scott_goddard
I am trying to sum the amount of time two words "high" and "very high" appear in a col....I can get this to work for one word but when i try and nest the...
April 21st, 2010 09:16 AM
by Scott_goddard Go to last post
6 107
Conditional formula by nordiyu
Date Name Approved Total 12-Jan-10 John Yes $120.00 15-Jan-10 Mike Yes $50.00 20-Jan-10 John No $300.00 31-Jan-10 John Yes $80.00 02-Feb-10 Mike Yes $50.00 05-F...
April 21st, 2010 04:25 AM
by nordiyu Go to last post
7 114
Convert times to text string by AZSteve
In adjacent cells (A1 and A2) I have formatted start/stop times showing as 7:00 AM and 5:30 PM. In cell A3 I want concantenated text to appear as...
April 21st, 2010 03:19 AM
by Teethless mama Go to last post
2 186
combining columns and using concatenate by Donna[_5_]
I would greatly appreciate your time in looking at this. I have 2 questions. The first is: I have 2 columns A and B. Many of the cells are blank in column...
April 21st, 2010 12:46 AM
by Donna[_5_] Go to last post
5 114
Filter by gjhilde
The filter is not working after adding columns to a large spreadsheet.
April 21st, 2010 12:12 AM
by Max Go to last post
1 121
comparing more then one column with numbers and letters by CherylK
I have 6 columns and many rows in a spreadsheet i want to create a formula that looks at two common columns and if the same replace a column with an amount...
April 21st, 2010 12:10 AM
by Max Go to last post
1 119
Looking For Sales Projections Run-Off Formula by Val
I regularly do sales run-offs where in I have an assumption of how many sales are made in a month (say 10 per month) and each customer subscribes to my...
April 20th, 2010 11:51 PM
by Val Go to last post
0 103
Calculating daily totals from multiple worksheets (Excel 2003) by Dhardy
Good Morning, I am working on a stat log that needs to provide daily, weekly and monthly totals for each staff member. I need excel to count the # of "x"...
April 20th, 2010 10:46 PM
by Dhardy Go to last post
4 127
Lookup value that falls between two values in a range and then som by Richard Radcliffe
I have an array with 4 columns: A B C D 1 435 578 ID1 2 12 113 ID2 3 1478 1879 ID3 etc ...
April 20th, 2010 10:20 PM
by T. Valko Go to last post
2 115
Open multiple spreadsheets and pull data by vbtrying
I'm writing an update routine that keeps 2 EXCEL 2010 spreadsheets in-sync. I'm using this code to open the first spreadsheet and read data into...
April 20th, 2010 09:53 PM
by vbtrying Go to last post
0 111
Total a column (or row0 by highlighting cells by Goldar
Isn't there a way to total a column of numbers without using the AutoSum function. I seem to remember that I could just highlight a series of cells and the...
April 20th, 2010 08:13 PM
by Luke M[_4_] Go to last post
1 108
Post New Thread


Display Options
Showing threads 1121 to 1140 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 05:35 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.