Summary: Is it possible to combine one or more functions in a single cell in Excel 2003? I tried today();now() but that didn't work. www.monkonline.tk ...
Summary: After saving a new file in Excell XP I can open it and find it in the explore. But when I try to use "search" function in excell it does not find it !...
Summary: I would like to ask is there a GoalSeek function that is in Ms Excell found in Visual Basic.Net ? Does VB.Net have such a function ? I would like some...
Summary: Hi, I am using Office 2007. I am trying to use the FIND function in VBA, Excel, to find a numeric value and return its row number. The value surely ex...
Summary: Hello I am trying to use the timer function in excel without much sucess, what i want to do is put a button in the spreadsheet, when it is clicked a t...
Summary: Does anyone know how you can use the RANK function when your array of data is in multiple worksheets within one workbook? For example, I want to see...
Summary: Hi all, does anyone know how to do this? In Excel 2003 I used the function "URLEncode", but it seems this no longer exists in 2007. Many hours search...
Summary: Note: the above works good if only used in one of the sheets in file. Otherwise it changes the sheet names. An alternative is to use ASAP Utilites un...
Summary: It is possible to find a 'best' solution. However it is probably impossible to achieve on the jobsite. You would need a cut list that would place dif...
Summary: ASAP Utilites has that as one of the over 300 functions not found in Excel. It is free and pretty good to have around. Sorting sheets is found under S...
Summary: Hi Guys, I know this is simple, but I'm very new to the MS office environment. Does someone know what I would do to add duplicate rows in excel based ...
Summary: Use the help function in Excel or Access. Both of them will walk you thorough it. Sometimes I think I understand everything, then I regain consciousne...
Summary: Hi all - first time poster here - been having at a multiple If AND statement in Excel that I just can't get right. There are four variables and I'm t...
Summary: You can write a formula (called "mySum" in my example) with Visual Basic in Excel: 1) Open the VBE by clicking Tools / Macros / Visual Basic Editor ...
Summary: I need help with the vlookup functions in excel. Let's say I have two tabs, the second tab is a pivot table based on the first tab. I want to build a ...
Summary: Hello Friends. Got another question for you. I want to know how to combine 2 Nested IF functions in excel into one cell with a condition before each o...
Summary: I am trying to assign a user defined VB function to excel cell. I wrote a s simple function called testy() in VB editor that returned a number. Fu...
Summary: How can I create a print button in excel so that the user by clicking it will get the whole document printed? BUT The page must not have any backgroun...
Summary: Dear I got a query about the if function in excel 2003 If I got a list of dates on each cell, each of these dates presents an exercise which was done...
Summary: I need to Sort an entire row by date automatically (close of escrow). I would like to be able to hit a button and the sheet sorts all the rows by date...