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
30 3,788
Calculating a running Average between dates by San[_4_]
Hi, I have a table consisting two columns - Date (dd/mm/yyyy) & Fuel Price...
December 10th 15 09:35 AM
by San[_4_] Go to last post
2 1,227
Validation list source is a list of comma separated values in asingle cell by [email protected]
Is there a way of making the validation list reference a single cell but in that cell is the list of acceptable values which are comma separated. I think this...
December 8th 15 09:33 PM
by GS[_6_] Go to last post
8 1,022
permanent conversion of 1904 date format to 1900 date format by Jos
I have an old spreadsheet in Windows that has the 1904 date format as basis. All my other spreadsheets are in the 1900 date format. Are there any utilities...
November 26th 15 03:48 PM
by Agostino Banchi Go to last post
4 2,646
Obtain the value in a cell offset form the first cell of a named range by [email protected]
I am trying to figure out a formula which obtains the value of a cell which is offset from the first cell of a named range. I have tried something like this...
7 965
Excel to oracle copy paste by [email protected]
i have excel file with 1000 lines with 4 fields like - 1 Amount 2 Tax code 3 cost center 4 discription right now am copy and paste it manually in oracle AP...
0 804
formatting numbers as 1st 2nd by Bob Arnett
Is there any way to display numbers in the mode of: 1st 2nd 3rd 4th etc. ?
(Multi-page thread 1 2)
13 1,532
Multiplying a Number Found in an Alphanumeric String by Randomerz
I am working on a project that someone none-too-bright started. The cell that I need to update looks like this: Monkeys $233 Dogs $159 Yes, these four line...
November 15th 15 05:13 PM
by Claus Busch Go to last post
9 1,415
1 Attachment(s) stock sheet by montypython
Hi Guys I have attached a template which can be changed I need to make boms or have scenario where if I enter 10 bent spikes for powder coating, it minuses...
November 11th 15 09:24 PM
by GS[_6_] Go to last post
1 871
Number values by CP514
Hello experts, i have a huge database of entries from a survey generated from google forms into excel. long story short i have various pivot tables and...
November 11th 15 08:53 PM
by CP514 Go to last post
3 758
FREQUENCY FORMULA by rhhince[_2_]
I have this formula in Excel 2003. =MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2001)),IF(AM$67:AM$2001<>AN4,ROW(AM$67:AM$2001)))) I am trying to calculate...
November 8th 15 10:01 AM
by abmmusic4 Go to last post
3 792
1 Attachment(s) Need Help With dates and linking it by Jaddo92
Dear Team, i have an excel sheet as per the attachment below what am trying to do i need to find a way on the right there's Days Left and before i have 2...
November 7th 15 01:59 PM
by Jaddo92 Go to last post
0 744
Static date not working using VBA by Joe Clarke
I am trying to insert a static date into column P (from p7 down) if the adjacent column is populated. I need it to remain blank otherwise and the O column is a...
November 6th 15 02:26 PM
by Claus Busch Go to last post
1 730
Help With Extracting Text String by tb
I am using Excel 2013 (32-bit) on a Windows 7 PC. I am trying to extract part of a string for each part number in my file. I would like to extract the string...
November 4th 15 12:29 AM
by tb Go to last post
2 672
Conditional Formatting not working right by Christopher Jack
Hello, I have a time tracker with calculated times, then based on input of actual times the color of the time is suppose to go red if greater then the...
October 24th 15 07:03 PM
by Christopher Jack Go to last post
1 942
formula to switch last/first name around? by Stilla
Is there a formula I can copy into say, cell B1, that will change a name in cell A1 from "Brown, John" to John Brown? Thanks to all you excel wizards out...
October 21st 15 06:07 AM
by Claus Busch Go to last post
8 3,900
How to save random numbers? by Rangemaster
Hi folks, Hopefully someone can help me with this question - it bothers me for hours now and I can't find the answer anywhere on the WWW. I'm making an excel...
7 1,541
Converting google flights results to Excel by [email protected]
Hi, I am not sure if this is the right group to ask this question but: I want to be able to copy google flights result to excel such that price, destination,...
0 878
Help with Multiple VLOOKUPs in an IF statement by dakota park
I have a table with the top row headers (classifications) of "LOW," "MIDDLE," "MODERATE," "UPPER," & "UNKNOWN." Under each are random (identification) numbers...
October 10th 15 01:08 AM
by MyVeryOwnSelf[_3_] Go to last post
2 749
Variable Page Break by Christopher Jack
Hello, I have a table that has the date in column A. The start date is variable based on the value in O1. From there, the next cell is calculate from the one...
October 9th 15 06:29 AM
by Claus Busch Go to last post
5 790
Post New Thread

Display Options
Showing threads 121 to 140 of 88499
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 11:13 PM.

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