Worksheet Functions - Page 441

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.

Thread / Thread Starter	Last Post	Replies	Views
function by Mac V. hi, I am trying to find out difference between "search" and "find" function. regards Mac	July 26th, 2009 05:13 PM by JoeU2004	2	136
Exporting data to Excel by Peledon How come when I export data to excel and reformat a column to numbers, it doesn't recognise them as numbers and I have to retype the numbers in a separate...	July 26th, 2009 05:12 PM by Jason[_39_]	6	122
ConditionalFormatCellValue by gh[_2_] I have a column with a middle initial or a middle namr or it is blank. What I need to do is add a period to the middle initial only. If it a missle name or...	July 26th, 2009 05:01 PM by Fred Smith[_4_]	1	87
A formula to choose the correct table for my template by Sky[_3_] Hi Everyone , Could anyone help me. I file consist of a table and a template. The table consist of a few Airport. The template is to calculate the total...	July 26th, 2009 04:45 PM by Sky[_3_]	2	102
Referencing text from another cell for criteria in functions by Tricia, not Patricia I know how to enter text as a criteria, but am looking for a way around manually editing the text when doing multiple functions. Example: I give out...	July 26th, 2009 01:48 AM by Fred Smith[_4_]	1	103
Formula corresponding to row it is in? by REBANEEDSTOKNOW Ok, I'm trying to have a function apply to an entire set of information. What I need is for the function to adapt to the row it is in... like, when I enter...	July 26th, 2009 12:00 AM by Max	3	88
scroll down today () with weekdays only by Stephen Christian I would like to use the today function as a starting point and scrolling down list the previous 70 weekdays, (25-7-2009 format), in a way that every time the...	July 25th, 2009 09:48 PM by Shane Devenshire[_3_]	3	96
Sort Excell cells that have each their own Validation criteria by geniet Hello all of you, I have a few cells that I want to sort (Data - Sort...). Each cell has, in my case, its own Validation criteria (Data -...	July 25th, 2009 09:23 PM by Shane Devenshire[_3_]	1	96
Date Validation and Cell Data by Stacy C Good morning, I am setting up a spreadsheet wherein I have a row for each day of a month, with numeric values. I need to be able to setup a formula similar...	July 25th, 2009 09:17 PM by Shane Devenshire[_3_]	4	91
Searching several items from one document to another by REBANEEDSTOKNOW Can't seem to find what I'm looking for, and I'm not too savy at this program, so what I'm trying to do is this... I have 2 documents, one is a database of...	July 25th, 2009 08:20 PM by Shane Devenshire[_3_]	3	110
replace state names with state code abbreviations by se7098 is there an easy way to search a workbook for state names and replace with state code abbreviations? the names are scattered throughout the workbook and...	July 25th, 2009 06:41 PM by Gord Dibben	3	92
Pivot Table by Jordan Is these a way to use a pivot table to count unique items in a set of data? Thanks for you help.	July 25th, 2009 06:14 PM by Herbert Seidenberg	4	105
VLookup+ Monthly Data by Chris26 Hi I am trying to save some time Cut and Paste. I have values as follows for each month Col A Col B Jan 5.15 Feb 3.20 - Dec 6.75 I then...	July 25th, 2009 05:19 PM by Bernard Liengme[_2_]	5	89
Pivot Table column total not working (Excel 2007) by scrimshander Hello - My first post to this group; thanks in advance for the help. I'm a fairly experienced Excel user, but can't figure out why the pivot table in the...	July 25th, 2009 01:13 PM by Jason[_39_]	2	96
Adding Round funciton to handful of numbers by Jamie Hi, I have a sheet filled with raw data. I need to round each number and was wondering if there is a formula or macro I can run to accomplish this. All the... ( 1 2 3)	July 25th, 2009 09:06 AM by Bernd P	21	206
tiny texas houses, tiny houses, tumbleweed tiny house company, tinyhouse, small houses, tiny texas houses of luling by Texas Bob tiny texas houses, tiny houses, tumbleweed tiny house company, tiny house, small houses, tiny texas houses of luling...	July 25th, 2009 02:13 AM by Texas Bob	0	113
if cell is blank then calculate how many days? by Machel What would the formula in C column be if I want to know how many days from the A column date to today - if the B column is blank? A ...	July 25th, 2009 01:19 AM by Shane Devenshire[_3_]	4	84
Can I expand a cell without expanding the whole column in Excel? by Monica Please let me know if there is a way to do this. Thank you!	July 24th, 2009 11:42 PM by Jason[_39_]	1	76
Help with tweaking formula by Johndb Community, Using the base of (which works): =SUMPRODUCT(--(ISNUMBER(H3:N3)),--(H3:N3=G3))*(B3="S") How would I...	July 24th, 2009 11:28 PM by smartin	5	83
Need formular to use with dates by NICKJAX Hi, I was trying to use the Formula SUMIF. What I need is to have two colums, one with Dates and the other one with results. I need a formula to recognize...	July 24th, 2009 11:11 PM by NICKJAX	7	88

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed