A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
IFERROR function with Hyperlink by [email protected]
Hi, I'm trying to use the IFERROR function with hyperlink functions. I want the worksheet function to work like this: IF the hyperlink to the specific...
0 1,007
Find Date Between? by [email protected]
Hello experts. I have an array of dates, like this: 08/07/2013 02/07/2014 08/07/2014 02/07/2015 08/07/2015 02/07/2016 08/07/2016 02/07/2017 08/07/2017
May 21st 15 01:11 AM
by Howard Silcock Go to last post
2 681
Inserting rows to linked Workbooks by Todd Gerdy
I have one workbook (inventory workbook sheet1) that pulls the information off of another workbook (data workbook sheet 1). If I try to insert a new row in the...
May 16th 15 05:59 AM
by GS[_6_] Go to last post
6 1,073
Using Vllookup with OFFSET or ??? by [email protected]
I'm trying to create a "Rollup" sheet with information from 5 other TABs. The TAB data is based on (for the example below) being in a TAB named AG (which is in...
0 559
Find duplicates w/3 criteria by [email protected]
I have tried various formulas to make this work and I'm spinning my wheels and hoping for help! I would like in column D a Y or N to indicate the cells in that...
May 11th 15 05:39 PM
by Claus Busch Go to last post
3 777
Vlookup and Countif by [email protected]
Good Day! I have a worksheet having "Names" in one column and "Status" (Pending or Complete) in the other column. I want to check name by comparing the...
May 11th 15 06:42 AM
by Claus Busch Go to last post
1 696
Convert YY[julian day] to dd-mmm-yy - Julian Date.xls (0/1) by Phrank
Hi, I'm trying to convert a 5 digit serial number to the manufacture date. The serial number is formatted as yy (e.g., 12080, which equates to a manufacture...
May 9th 15 07:18 PM
by Phrank Go to last post
2 890
Compare numbers based by day of the week and month by Emilio Guerra
Hello, I have to compare numbers based on day of week, since there are many fluctuations between weekdays and weekends. I have a spreadhseet for March and...
May 9th 15 11:23 AM
by trantrongtb Go to last post
2 790
Help ASAP with formula! by LouisCG3
Hello! So I am having a really BIG problem coming up with a formula.. Here's the issue: I have a number in E11 that is negative. I'm trying to subtract two...
May 8th 15 01:09 AM
by LouisCG3 Go to last post
4 664
Conditional formating Excel 2010 by [email protected]
Help please: I have some look up formulas on a spreadsheet and I have this row to showup red if a cell is larger than the median wich I have a formula at the...
0 555
Spreading number evenly over 165 days by LightningEclipse
I need an Excel file which can sort a given number (22) evenly across the days of a year (165) without decimals (so they need to be rounded), so that I can see...
April 29th 15 11:15 PM
by Don Guillett[_2_] Go to last post
1 721
Cannot bring out the month & year from a date by San[_4_]
Hi I would like to bring out the month from a given date in the format 'mmm-yy'. The original date is in dd/mm/yyyy format. But when I am using the Month...
April 29th 15 01:28 PM
by San[_4_] Go to last post
3 617
Multiple returns with one lookup value by L. Howard
The typical answer to a vlookup trying to return multiple values. List has 3 lookup values, and vlookup returns first only. So INDEX SMALL formula is the...
April 25th 15 07:42 AM
by L. Howard Go to last post
2 666
CONCATENATE - #VALUE! error sometimes ???? by [email protected]
I have a multi sheeted workbook, currently in EXCEL 2003. On each sheet of the workbook, in cell A2 I have CZ in cell A3 I have 23 in cell A1 I have...
2 1,090
Excel INDIRECT or CONCATENATE ? by [email protected]
I am struggling with either INDIRECT or CONCATENATE in (Excel 2003 or 2007 I have access to either). Using a multi sheet workbook, every month I have to go...
April 16th 15 10:52 PM
by simnamsinh Go to last post
1 751
Returning contents of a cell identified by two logic tests by SteveRH
The attached spreadsheet extract (please excuse the format, and why can't I upload the spreadsheet?!?)is a much smaller version of a live problem I can't fix...
April 15th 15 02:20 PM
by Claus Busch Go to last post
3 733
Conditional formatting on dynamic named range by Håkan Björkström
Hello I have an Excel 2007 sheet with a dynamic named range, "WholeMain", to which I apply some conditional formatting. When I apply a formatting to range...
April 15th 15 10:15 AM
by Håkan Björkström Go to last post
2 630
offset formula causing Circular reference by Fighting Illini Mike
I have come across this before but don't know what the solution is. I had a Excel 2010 workbook open with many offset formulas in it when I opened an old .xls...
3 1,020
SUMIFS ? for multiple ranges by L. Howard
The formula to sum "C" in these four tables escapes me, if it is even possible. My SUMIF, SUMIFS & SUMPRODUCT search comes up with no "four-way"...
April 10th 15 07:47 PM
by L. Howard Go to last post
4 783
How to change the direction of the enter key to go horizontal by BManske
I recall when entering data in an excel chart, that I could change the direction from vertical to horizontal when using the "enter" key.....and can't...
5 3,864
Post New Thread

Display Options
Showing threads 201 to 220 of 88510
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 On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.