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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Please help., by ck13
Basically you will have a table of data. In VLookup there are 3 things, lookup value, table array and column. Note that the lookup value has to be on the...
May 27th, 2010 08:53 PM
by ck13 Go to last post
0 181
Counting occurance of empty cells by DaveC
Perfect thanks, worked a dream "Tom Hutchins" wrote: Try =SUMPRODUCT(--(LEN(J157:J2643)0),--(LEN(K157:K2643)=0)) I used column K per your...
May 27th, 2010 08:53 PM
by DaveC Go to last post
0 172
Algebraic Functions by Jpleasant
How would you solve a function with input 1 output 8. Then input 2 output 14. next input 3 output is blank then input is blank Output is 24. the input is...
May 27th, 2010 08:53 PM
by Jpleasant Go to last post
0 214
Formatting Text to Numbers for Dates by Huber57
Tommy, I assume the date you meant was 21/06/2010 and that the format is dd/mm/yyyy. If so, use this formula to turn it into a...
May 27th, 2010 08:53 PM
by Huber57 Go to last post
0 257
pick up particular number from a table by Lowan Chan
sorry, D1 and E1 should be 05/10 -- Lowan "Lowan Chan" wrote: Hi, I have below table:
May 27th, 2010 08:53 PM
by Lowan Chan Go to last post
0 219
Single click selects multiple cells by Mike1558
When clicking on a single cell multiple cells are selected. The one time solution for this is to zoom in or out. This is problematic as 60% seems to be the...
May 27th, 2010 05:34 PM
by Hinson Stephens Go to last post
7 342
How to access macros via tool buttons? by Mel
Excel v2007 When using v2003, I had many macros In my Personal.xls, which I accessed via custom tool buttons on many custom toolbars that I built. I now have...
May 27th, 2010 04:16 PM
by Ron de Bruin Go to last post
2 339
Macro not working correctly by Andy_N1708 via OfficeKB.com
Hello all, I have written a macro that looks at one column of text and depending on what is in the cell of that column, the macro would copy a template...
May 27th, 2010 03:35 AM
by Per Jessen[_2_] Go to last post
3 355
Test by T. Valko
test -- Biff Microsoft Excel MVP
May 26th, 2010 06:27 PM
by T. Valko Go to last post
0 216
Pivot Table Page Field value from cell in another worksheet by kernel
I have looked through the other posts on the subject and the combination of my low skills in VB and the other solutions not exactly covering my situation...
May 26th, 2010 05:54 PM
by Roger Govier[_8_] Go to last post
3 286
CellinFooter() Specify Which Sheets are updated by Microuch
I have spent much of the morning looking at various forums & threads but had no luck finding exactly what I need. As you can see the code below updates the...
May 26th, 2010 05:13 PM
by Gord Dibben Go to last post
3 244
cross-hares by PBG
Back in the day, when you selected a cell, you were able to have a line appear vertical and horizontal I believe with your curser. It looked like...
May 26th, 2010 05:12 PM
by Gord Dibben Go to last post
1 203
Past Special- Transpose Function? by Going Crazy with excel[_2_]
I have a master data base of 20 columns of data. I want to transpose only 6 columns of that data to a different sheet, automatically recognizing the column...
May 26th, 2010 12:36 AM
by Fred Smith[_4_] Go to last post
7 258
Need help looking up data-vlookup isn't working by MMcGee
I have 2 worksheets. Column A in sheet 1 contains values that I know are in column A of sheet 2. I need only the rest of the values in sheet 2 (in other...
May 25th, 2010 10:17 PM
by MMcGee Go to last post
5 261
Macro to Cut and paste Values by tr
I have a workbook with many lookups to external workbooks via function. INDIERCT.EXT This works fine.....but is very slow; as it cycles every associated...
May 25th, 2010 09:58 PM
by tr Go to last post
2 268
Use Macro To Change Which Macro Assigned To Command Button by CVinje
I'm trying to create a macro that will change the macro associated with multiple Command Buttons on my spreadsheet. I've been able to use the macro recorder...
May 25th, 2010 09:55 PM
by CVinje Go to last post
0 214
Need To Track Advertising by clarkshvac.com
I am looking for either an Excel Ttemplate or a formula that will do the following: 1. Enter various methods of advertising, ie, print, online, radio etc. 2....
May 25th, 2010 09:11 PM
by clarkshvac.com Go to last post
0 185
Color differences in Mac Excel by Vicky
Hi, We create Excel files with conditional formatting on Windows XP pcs. The colors depend on the value of the cell: typical formatting i.e. red = bad,...
May 25th, 2010 08:30 PM
by Mike Middleton[_2_] Go to last post
1 269
summing two columns of different data by Dick Scoppettone
I need to sum a dollar total from two different types of columns. One column identifies the item and another column associates a dollar amount with that...
May 25th, 2010 08:02 PM
by Dick Scoppettone Go to last post
4 293
Best place/book to get advanced training? by JS
I've been using excel for a long time, but my new job requires me to be more of a power user than I currently am. Any suggestions on online course/tutorials?...
May 25th, 2010 07:42 PM
by Gary Brown[_6_] Go to last post
1 316
Post New Thread


Display Options
Showing threads 501 to 520 of 139764
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 04:01 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.