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 Replies Reverse Sort Order Views
Vertical lookup of pictures by DJDKAL
I am trying to see if there is a way to lookup a picture in one tab and insert it into another tab all within the same worksheet. I have tried the embed...
(Multi-page thread 1 2)
March 22nd, 2010 04:24 PM
by Gord Dibben Go to last post
14 290
Advanced Filter Question by Pieyed Piper
I want to use a named range, which is a single value as the "equal to" criteria in the advanced filter dialog box. I have a named range of a single cell I...
(Multi-page thread 1 2)
November 19th, 2009 01:37 PM
by MeowSayTongue Go to last post
14 402
Fun with SUMPRODUCT by rweiss
Trying to solve for the following: Count if 1) Priority = "Must" AND 2) Status "Closed", "Accepted", or "Testing" AND 3) Functional Area...
(Multi-page thread 1 2)
November 19th, 2009 12:04 AM
by rweiss Go to last post
14 216
Count cells based upon criteria in other cells by JT
The cells in column J contains donations made by various individuals. Cells in column R contain certain member classifications. Am looking for a formula...
(Multi-page thread 1 2)
December 20th, 2009 10:06 PM
by JT Go to last post
14 195
how do i retrieve the largest value from several records/rows in e by Louis
i'm trying to retrieve the largest value from a field. the records are many but i only want to include the records related to a specific person. "DMAX" seems...
(Multi-page thread 1 2)
January 5th, 2010 02:33 PM
by Max Go to last post
14 232
Help by Steve
Howdee all. I was just presented with a problem that has got me curious. While it's something I have thought about before, I never knew where to begin with...
(Multi-page thread 1 2)
January 6th, 2010 06:35 PM
by T. Valko Go to last post
14 199
VLookup by L.Mathe
I'm working with Excel 2003 and created a workbook (1 worksheet) to compare 3 columns of data. Each column varies in number of rows, but could have as many...
(Multi-page thread 1 2)
March 9th, 2010 01:45 PM
by Max Go to last post
14 272
Why does it display #### in my cell? by Lindsey-Star
In cell I25 I have the following formula: =SUM(I11:I14) All it displays is #####, but when I hover over it, it gives me the correct answer on a popup...
(Multi-page thread 1 2)
March 15th, 2010 12:32 AM
by Joe User[_2_] Go to last post
14 598
Date Function by Jen_T
If a cell has text and numeric (date) is there a way to pull the date out easily ? E.g. Product dropped off on 11/01/2009 by Michelle Smith I would like to...
(Multi-page thread 1 2)
March 28th, 2010 04:14 AM
by Rick Rothstein[_2_] Go to last post
14 341
Selecting all the active cells in a named column. by Colin Hayes
Hi I have a small problem. I need to have a macro which can fulfil the following , if possible. I need to select all the cells in a named column. Not the...
(Multi-page thread 1 2)
October 22nd, 2009 04:47 AM
by Colin Hayes Go to last post
14 218
Add cells on two adjacent rows but non-adjacent columns by Eve
Hello, Thank you for helping, as I am not too familiar with the advanced funtions of Excel. I am working with a very large worksheet and would like to add...
(Multi-page thread 1 2)
October 20th, 2009 02:32 AM
by Eve Go to last post
14 203
How to count number of characters in xl cell for publisher merge by msloell
I am doing a catalog merge in publisher. Data is in XL. Publisher has 255 character limit on merged info. How do I count the characters before I execute the...
(Multi-page thread 1 2)
October 22nd, 2009 06:43 PM
by Prof_Hinkle[_2_] Go to last post
14 193
I found Row 14 in wksh 2, can I get the value of J14 into wksh 1? by grateful
Hello. I feel like I've gotten far, but not far enough...If you can help, I would be greatful. Thank you. I used this formula to identify the row I was...
(Multi-page thread 1 2)
September 7th, 2009 09:23 PM
by grateful Go to last post
14 116
concentrate muli cells by Dylan @ UAFC[_2_]
I need to concetrate 1000 cells into one single cell seperated by , and space please advise
(Multi-page thread 1 2)
November 24th, 2009 06:36 PM
by [email protected] Go to last post
14 293
Counting using data from 2 columns by darbs
I need to count the number of rows which have a particular date in column A and then a particular name in column J, I have tried countif formula but can not...
(Multi-page thread 1 2)
July 27th, 2009 04:26 PM
by Eduardo Go to last post
14 165
Calculating number of workdays between 2 dates by Gibbyky2
here goes i use excel 2007 and can calculate number of days between 2 dates using networkdays function. but my colleagues use older versions of excel and...
(Multi-page thread 1 2)
August 24th, 2009 12:02 AM
by barry houdini[_28_] Go to last post
14 310
Validation drop-down boxes by Tami
i know this is a long shot but i thought i'd try asking... I have a spread sheet that has the validation drop down box pointing to a list in column...
(Multi-page thread 1 2)
September 21st, 2009 03:57 AM
by Debra Dalgleish Go to last post
14 255
xldynamic is back by Bob Phillips[_2_]
I forgot to mention that the xldynamic site is back up, I have resolved my host provider. I still have to fix the downloads, but eveything else should be...
(Multi-page thread 1 2)
September 28th, 2009 09:32 PM
by Bernd P Go to last post
14 229
How to write an `IF` and an `OR` formula by Romileyrunner1
Hi, I want to write the following: (but this doesn`t work) =IF(H751, OR I751,"A",("")) Meaning, If value in H75 1 OR if value in I751, then put in an...
(Multi-page thread 1 2)
October 4th, 2009 04:19 PM
by Bob Phillips[_2_] Go to last post
14 266
Id'ing tabs that contain #REF!'s by Steve
I have a workbook with quite a few sheets, many having formulas that refer to other sheets. Sometimes when I make changes to some of the cells in certain...
(Multi-page thread 1 2)
April 21st, 2010 09:00 PM
by Steve Go to last post
14 319
Post New Thread


Display Options
Showing threads 1001 to 1020 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:59 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.