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 Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Formula Help by tj123001
I am trying to get this formula to work. =IF($B$2="",SUMIFS('Revenue Data'!$E$2:$E$2426,'Revenue Data'!$N$2:$N$2426,'Total Summary'!$B21,'Revenue...
February 15th 13 01:22 PM
by Stan Brown Go to last post
2 278
Moving Average by Prets
Hi everyone, I have been given a project to do but am a little stumped and hoping someone could give me some assistance/advice. We have several sites and...
February 15th 13 11:43 AM
by Prets Go to last post
0 303
Start sheet in a workbook by Stuart[_32_]
I use Excel 2010. In one workbook, which I use frequently, I always want to open at the same sheet. I found a setting in Options once and it worked fine but...
February 15th 13 11:23 AM
by Stuart[_32_] Go to last post
2 305
Excel date formate doesn't change by jennifer barclift
Export data from Servce manager ams1 sm9 create csv fle want to change the format to mm/dd/yyyy mm:hh. tred several seneros 21/01/2013 10:45:37 21/01/2013...
February 14th 13 05:35 PM
by jennifer barclift Go to last post
0 381
lookup 2 columns, return value from third by slezgus
I have two tables of pretty much the same format. Column A shows a name that may or may not be repeated a few times, while column B shows one of four values...
February 14th 13 05:11 PM
by vba_n00b_CA Go to last post
3 3,072
Excel on Iphone by Gary Ridgway
A supplier of mine has sent his invoice via e-mail in .xls format. It reads perfectly well on my Iphone but when trying to view attachment on my PC all I get...
February 13th 13 11:10 PM
by GS[_2_] Go to last post
1 399
Transpose by ukat101052
Posted this on Mr Excel. I have several worksheets in one workbook entitled, "A", "B", "C", "D", and "E". In A1 of each worksheet is the title of the...
February 13th 13 09:06 PM
by zvkmpw Go to last post
1 358
Excel dup names not listed merge cells by KA0812
I have a spreadsheet example below: Device Name App Owner King 123 Brown Queen 567 ...
February 13th 13 01:42 PM
by Ron Rosenfeld[_2_] Go to last post
1 402
hide row with drop down value by Rodog
hello, i need help with the code for this project, the way it should work is when you select the drop down list in 'B5' and select 'dragline' row 91-153 will...
February 13th 13 07:45 AM
by Rodog Go to last post
0 292
Question
Excel Bug by cincinatus_c
I have a rather complicated spreadsheet with about 30 interlinked tabs running cash flow analysis - it's definitely a workhorse spreadsheet. The last couple of...
February 12th 13 10:30 PM
by cincinatus_c Go to last post
1 416
trying to figure out Count feature by wannabe_guru
I have an aging report where I need to determine the value in the "oldest" bucket. Column Header: 1-30 31-60 61-90 91-120 121+
February 12th 13 03:49 PM
by wannabe_guru Go to last post
0 244
Excel: I want to assign numeric values to letters in a speradsheet by Marion Black
Hi, Any help would be very greatfully received! I am trying to work on a spreadsheet for a staffing rota. Each shift type has a letter (i.e. E or LS). I need...
February 12th 13 09:00 AM
by Cmtes Go to last post
4 4,149
Unhappy
Shared File problems over VPN by Saint Mexico
Hello everyone - I am having a problem with shared workbooks when using over an VPN. when opening the file, it comes up as "in use by another user", which...
February 11th 13 07:17 PM
by Saint Mexico Go to last post
0 475
Copy rows to new sheet based on value in column A by Fredy617
I have a sheet which a person will add data to every day. In the left hand column are the account numbers. I need a macro or VBA to copy the rows of each...
February 11th 13 06:29 PM
by Fredy617 Go to last post
0 439
Subcategories in Drop Down List by pspork
Is it possible to get a drop down list that is pulled from two different lists? Such as: Roof -Demo -Rebuild Floor -Demo -Rebuild Structure
February 8th 13 10:22 PM
by GS[_2_] Go to last post
2 339
Delete certain text from cells by ukat101052
I have a column of data (>50 cells), with some cells blank. In certain of the cells, there is a dash that separates the first word in the cell, and the...
February 8th 13 09:35 PM
by ukat101052 Go to last post
2 423
Trying to create a dynamic filepath within VB by Steve[_11_]
Hi Is it possible to amend the code below so that the filepath is determined by the contents of a cell, say Sheet1!B$2$? The code is the start of a macro that...
February 8th 13 07:57 PM
by GS[_2_] Go to last post
3 393
Splitting multiple values in cell & automatically running a conversion between units by Harry827
I've got cells with a range of values and different units. Here's an example of what I'm looking for.. 1 apple (appl) = 3 oranges (org) 14 apples (appl) = 1...
February 7th 13 11:52 PM
by Harry827 Go to last post
2 454
No tools manu? by Martin [_2_]
Hello I have no tools menu, is there a utilitly I could use? Using Excel 2010 Thank you -- Martin
February 7th 13 03:50 PM
by Martin [_2_] Go to last post
0 324
highlight cursor row by KUlibacct
A spreadsheet program (not sure which) I used to use would highlight the row that the cursor was on when working in a spreadsheet. This helped in scanning...
February 7th 13 04:58 AM
by LaurieDD Go to last post
5 1,693
Post New Thread


Display Options
Showing threads 1001 to 1020 of 146436
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 06:47 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.