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
Running Macros in protected workbook by petunia
I have a macro in a protected workbook that won't work correctly with it protected, how can I get the macro's to work
January 18th, 2005 10:24 PM
by Paul B Go to last post
3 141
Large() with twist by Dan
Hello, I am interested in returning the name(s) of a product if it is one of the top 5 money makers for the year. I believe the large() can return me the...
January 18th, 2005 10:53 PM
by Aladin Akyurek Go to last post
2 95
SUMIF FUNCTION by Bel
For hourly employee, I need to add total hours for each day. But some day, they are off. I put " off" in this case. The format like this: A 1. 8 2. 3 3. OFF 4....
January 18th, 2005 11:20 PM
by Jason Morin Go to last post
1 114
Weekly Transaction Processing by Ralph Howarth
I have a download report in *.csv that I want to use MS Excel to convert into another *.csv every week. The purpose is to prepare transactions for importing...
January 19th, 2005 06:37 AM
by Ralph Howarth Go to last post
4 878
Is there a VLOOKUP substitute when data is not in ascending order by VJ7777
I need to create a report (from multiple workbooks) of activities that are to occur "today" from a list of dates (Column A)and events (Column B). but the dates...
January 19th, 2005 09:32 AM
by Arvi Laanemets Go to last post
2 151
Date conversion by Gerrym
I want to convert a number i.e. 041006 into a date, having formatted the new cell as date: dd/mm/yyy. When I use the formula ...
January 19th, 2005 10:46 AM
by Bob Phillips Go to last post
3 179
Formula to return cell contents based on multiple conditions by Bill
I'm trying to write a formula to display the contents of a cell found within a named range based on multiple criteria. I've written similar formulas in the...
January 19th, 2005 10:59 AM
by Max Go to last post
3 623
Converting text to a number by Helen Black
I am trying to do a sheet containing Holidays and Absence my problem is that if you only have a 1/2 day holiday my formula is counting it as a full day I need...
January 19th, 2005 02:33 PM
by Helen Black Go to last post
2 123
Count based on color by John Kirschner
I need to use a formula that does a count based on font color. Is it possible? And do you have an example I could see? -- John Kirschner
January 19th, 2005 03:27 PM
by Ola Go to last post
2 125
Using wild card characters in array formulas by PJB Shark
I'm using an array formula to count occurrences of certain text values in a column. The column contains various 2-letter codes, and I want to count the number...
January 19th, 2005 04:09 PM
by Jason Morin Go to last post
3 228
In Excel, I need to now how to pick the second highest number in . by Keith
I am attempting to do inventory analsysis where I need to pick the highest and second highest values from a row of numbers. I can get the highest by using the...
January 19th, 2005 04:23 PM
by Keith Go to last post
4 208
Calculating an AVG from data on another sheet by flummoxed
Let's say I have 2 columns of data on worksheet "Data" - column A is date, and column B contains numeric values. Using a date found on worksheet "Test" (in...
January 19th, 2005 04:25 PM
by flummoxed Go to last post
3 109
SUM values between dates by Qaspec
I have 2 columns D7:D36 and E7:36 Column D contains dates ie: 9/7/2004 Column E contains a value ie: 2 In another cell I would like to add the values for...
January 19th, 2005 04:45 PM
by JulieD Go to last post
1 204
can you prevent viewing of specific columns in a worksheet by Tamara
Would like to share an excel worksheet, but both protect modification of the entire worksheet (simple enough -- know how to do that), but would also like to...
January 19th, 2005 05:12 PM
by JulieD Go to last post
1 273
Is it possible to create a limiting value for a summation? by Duncan, UK
I am trying to do a similar, but capping a cell that I use for discounts eg the cell could read 35%, but I only want a max of 30% on some products But the...
January 19th, 2005 05:59 PM
by Duncan, UK Go to last post
0 80
sum values between today and 6 months prior by Qaspec
I have a colum with exact dates and another with values that correspond to those dates. Columns D and E respectively. Rows 7-36. What I would like to do in...
January 19th, 2005 09:17 PM
by Qaspec Go to last post
3 86
Creating a Formala by Jenn
Here's my scenerio: Sheet 1 is the main page with all the information (a quotation with material and price breakdown). In columns A & B data has to be entered...
January 19th, 2005 10:16 PM
by Jenn Go to last post
2 89
Finding the maxium value of a column by feman007
Hi, Is there a way to find the maximum value of a column in Excel and then list it along with the corresponding values in adjacent cells in the row? I know it...
January 19th, 2005 10:17 PM
by feman007 Go to last post
5 99
Sheet Names and Cell References by Reed
Hi, I am using the formula below and others like it to extract certain data from a single workbook into several different workbooks. I have multiple sets...
January 19th, 2005 11:17 PM
by Jason Morin Go to last post
1 196
LOOKUP and COUNTIF by borris
hi all, i wonder if anyone can help me with a formula i want to create. in column A i have names of products, and in column B i have the date (sell by date,...
January 20th, 2005 12:02 AM
by JE McGimpsey Go to last post
5 110
Post New Thread


Display Options
Showing threads 10041 to 10060 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 12:32 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.