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
FORMAT CELL TO MILLIMETERS by kjboyle
Is there a way to format cells to millimeter measurement?
April 22nd, 2009 04:41 AM
by Gord Dibben Go to last post
3 85
comparison function by NEHicks
I have 2 worksheets - Worksheet A Name, SSN, Discharge Date, Discharge Appointment Time, Discharge Time Worksheet B Name, SSN, Ward, Discharge Appointment...
April 22nd, 2009 03:20 AM
by smartin Go to last post
1 133
VLOOKUP displaying "NO ANSWER" instead of "0" by ksean
When using this formula everything works great as long as an answer can be found but when an answer can't be found the answer displays as a "0". What do I...
April 22nd, 2009 03:18 AM
by Fred Smith[_4_] Go to last post
2 63
Return two random lines by Jeremy
I need to randomly select two lines per person listed on my report. How can I do this?
April 22nd, 2009 03:16 AM
by smartin Go to last post
1 85
count number of dates in a row of cel before or after a variable d by TBA
Hi there. I want to create a formula to count the number of dates that fall before or after a set date. The sheet is structured so that there is a column...
April 22nd, 2009 03:08 AM
by Fred Smith[_4_] Go to last post
5 92
Self Population of Date Function by SW[_4_]
I have formulas in a column that self populate dates in each succeeding cell. I would like to be able to have the cells stop self populating on the 25th of...
April 22nd, 2009 03:05 AM
by Fred Smith[_4_] Go to last post
1 96
macro writing by dannyboy8
Good afternoon, I have several worksheets that are pulling information from a company drive, the worksheets are pulling information from several sources but...
April 22nd, 2009 02:51 AM
by smartin Go to last post
1 72
Medians of data by Pendelfin
Hi Please can anyone let me know what the formula would be to let me know the median of a range of numbers depending on the types -...
April 22nd, 2009 02:47 AM
by T. Valko Go to last post
3 64
Can I use cell data for a web search & bring back in the results? by Jason
I have a list of companies in Excel that I want to use in a web search(google or live or yahoo) for their addresses and bring in their address back into the...
April 22nd, 2009 12:30 AM
by Don Guillett Go to last post
1 66
Drop down menus by Kirsty
Afternoon, When using drop down menu's, is there a function that when you type in the first few characters it finds the name, rather than scrolling through...
April 22nd, 2009 12:17 AM
by L. Howard Kittle Go to last post
2 55
Count With Multiple Criteria, please help!! by Kristina
I need some help with a formula in excel. Iwould like to be able to count the number of times each Item code appears for each store. Here is the data...
April 22nd, 2009 12:08 AM
by Kristina Go to last post
3 56
conditional list by sailingHLA
I am trying to create a dependent list for a drop down menu. My table is set up as follows: A B Mammal Cat Mammal ...
April 21st, 2009 10:35 PM
by Dave Peterson Go to last post
1 56
extract items from filtered list by andy62
I need to set up a report that dynamically displays on another sheet items from one column of a filtered range. After the advanced filter is executed, I may...
April 21st, 2009 10:01 PM
by T. Valko Go to last post
1 59
Can't sort with Excel 2007 by caherpeak
I was able to sort large tables easily with Excel version 2003. With Excel 2007, sorting does not function effectively. There are entire gaps in between rows...
April 21st, 2009 10:01 PM
by caherpeak Go to last post
0 46
symbals by menard, joseph
where is the symbal selection?
April 21st, 2009 09:26 PM
by FSt1 Go to last post
1 56
How to equal a cell in another worksheet incl fill colour by InNeedOfAssistance
I have four active worksheets (one for each Quarter) and one Annual worksheet which displays all the information of the Quarterly sheets. The annual...
April 21st, 2009 08:54 PM
by Rick Rothstein[_2_] Go to last post
3 89
Close Match by [email protected]
Hi All, I have two sheets ( sheet1 and sheet2) Sheet1 Col A has Client name ( unique ) - Approximately 20,000 Rows Sheet 2 Col A has Client name and Col B...
April 21st, 2009 08:35 PM
by [email protected] Go to last post
0 56
vlookup removing characters by ryan
I'm trying to lookup a value where my lookup_values contain extra text. e.g. lookup_values = "Los Angeles, CA TOTAL the table array will have Los Angeles,...
April 21st, 2009 08:28 PM
by ryan Go to last post
2 48
Copying Cells to new row on different worksheet by SPISO
I am in the process of developing a workbook including charts (Like a dashboard)where indivdiuals could enter the # of wigits produced today in one...
April 21st, 2009 08:23 PM
by SPISO Go to last post
0 61
How do I make a box with a check mark when clicked? by SongbirdVL
I am trying to create a form that has boxes in which people can enter a check mark by simply clicking on the box, no text required. I'm using Excel 2003.
April 21st, 2009 08:09 PM
by SongbirdVL Go to last post
4 74
Post New Thread


Display Options
Showing threads 11921 to 11940 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:02 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.