Office Software Forum - solved topics
- Excel (9,853)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
- Solved
-
connecting outlook with gmail Solved/Closed
Hello, plz suggest a way to synchronize my gmail account with outlook thanku
-
sum column if date (year) is greater than 09 Solved/Closed
Hello, Hi I'm trying to calculate 2 column if the date is greater than 2009 in Column A Column B Column C 5/31/2009 ...
-
Cell Reference Solved/Closed
Hello, I need a formula that can check a specific value in a range of values and show the cell location for each time the value is find Suppose we...
-
format nard drive Solved/Closed
Hello, i want to clear my hard drive and then relaod win xp, i have no real idea where to start and what i should save first ect ??? can anyone advi...
-
delete all rows except first and last row Solved/Closed
Hello, I have an excel file, I need to delete all rows in this file except for the first and second row. First Row = header row last row = contai...
-
formula or else ??? Solved/Closed
Hello, I have a range of cells B5:AC5 containing each a letter from a name, ex: DAVID THOMAS SMITH So B5=D, C5=A, D5=V, E5=I, F5=D..and so on up to ...
-
Need to sum Coumn F only when B & C identical Solved/Closed
Hello, I am trying to set up a formula that will allow me to get the average of values in F, but only for the rows where both Coumn B & C are identic...
-
If X is between A and B, then C Solved/Closed
Hello, Worksheet 1 Jan 10 Jan 12 Jan 12 10am Jan 13 Jan 15 Jan 16 9am Worksheet 2 Jan 11 I'm having trouble coming up wi...
-
Excel Help Solved/Closed
Dear All, I really need your support with my issue: I have around 70 tasks in Sheet1 some of them done with 100% (according to other numbers in th...
-
VBA Code that will find, copy and transpose Solved/Closed
Hello, I'm looking all around for a VBA code that will: 1 - Search down one column for the word "ADDRESS" 2 - Once "ADDRESS" is found, I need t...
-
how to count rows which show specified dates Solved/Closed
Hello, I am trying to get help with stats. I have a spreadsheet which shows the date a specific action was started in each row. I need to be abl...
-
select Y in all 3 columns and return value Solved/Closed
Hello, There are 3 columns where range is unknown for all the 3 columns( A, B & C). Macro need to selcect "Y" in all the 3 columns then No action ...
-
Incorrect Product Key Solved/Closed
Hello, I have just purchased a new computer. A Windows 7 Acer, actually... Well, as a new computer, a Product Key is required... right? See, Micros...
-
Reg: Macro - Auto run Solved/Closed
Hello, I need to run a macro automatically when i open an excel sheet. and aslo to run a macro when i close the sheet can any one help me...
-
VLOOKUP HELP Solved/Closed
Hello, I would be very thankful if anybody solve my problem which exactly need. The details are given beloW: DATE SCRIP NET(Cr/Dr) 19-...
-
I receive PDF files but can't open them. Solved/Closed
Hello, I have windows XP and when I receive an e-mail with a PDF file attached I try to open it and all I get is grafeate. Is it the Windows XP th...
-
Macro question Solved/Closed
Hello, I'm trying to write a macro in excel 07 to select the last row in a range. I want it to select the last row of the range only. Does anyone...
-
Excel Solved/Closed
Hello, I need some help. I would like to find out how many occurences of the same number occur in a column with in excel. Eample: 11111555555556666...
-
Excel MAtching Data Solved/Closed
Hello, I have two rows of data in excel one has the name of all members about 100 and the other list is of members who have paid their dues about 5...
-
where does the reference (weekends/holidays) Solved/Closed
Hello, in regard to your formula in counting days. you said that a list of holidays/weekends should be created. onces it is created where does that i...
-
How to Update Prices in Excel by % Solved/Closed
Hello, I have a lengthy spreadsheet (Office 2007) with stocked items and their prices, the prices are simply entered in a cell when I created the spr...
-
excel: if then else with multiple criteria Solved/Closed
Hello, Essentially, I would like to determine a numeric value (1-9) for the letters of the alphabet. Returning the number value in relation to a n...
-
VBA/Macro: Removing titles Solved/Closed
Hello, I need to remove Mr/Mrs/Miss preceeding the names in one cell and copy them to another cell. Any idea? Your advice is much appreciated. i...
-
I NEED A FORMULA IN EXCEL? Solved/Closed
Hello, Hello... I have a cell A1 that show $200.00. now if am type $ 200.00 in B2 automatically A1 cell amount should show as 0 your help much ap...
-
IF statement Solved/Closed
Hello, Please help me with the following if statement : =IF(A1:A34"Ba","Ba","") Column A1 to A34 contains the following text :Co, Cs, Th, Nk et...
-
how can i open my files without password Solved/Closed
Hello, i lock the forder with "free hide folder" software, i forget the password how can i open my files without password
-
constant in formula Solved/Closed
Hello, I am trying to use a input cel in excell 1) On my excel sheet I have data on A1,A2,A3,A4,A5 containing the amount of ml ink being used. ...
-
countif function Solved/Closed
Hello, I'll like to know if i can use the coutif function on multiple values? for example: =COUNTIF(E2:E30,(AND(G2:G30, "=הסתיים",A2:A30,"=11"),"=...
-
marcos Solved/Closed
Hello, I had someone help me make a marco in excel three years ago in office 2003. the mecro worked fine, but now I have installed office 2007. I can...
-
Stay on same row when selecting next sheet Solved/Closed
Hello, I would like to know how to stay on the same row when selecting another sheet. My file contains 17 sheets. Sheets 2 and 5 till 16 contain...
-
Stable Date Solved/Closed
Hello, Is there any function in Microsoft Excel where in we can get a stable date, the date should not change as it changes depending on the system ...
-
Help with Excel Macro Solved/Closed
Hello, I am certainly a macro noob and require some help, please, :( I work at a travel agency and I have a worksheet with all of our reserves. It h...
-
using a named cell in a macro - same workbook Solved/Closed
Hello, seems simple but I'm just not getting it....I'm using excel 2003 and am trying to use a named cell on one sheet in a macro on a different sh...
-
Activate userform in userform Solved/Closed
Hello, I've just started exploring the possibilities of userforms. My userform contains a TextBox named "txtAanvraagDat". In this textbox a date...
-
COUNT # ROWS where 2 conditions are true Solved/Closed
Hello, I am having problems counting the # rows of problem reports where the priority = 1 and the PR is active. here is the array: PR PRIORI...
-
Excel 2007 Formula Help - if cell is empty... Solved/Closed
Hello, Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get t...
-
excel issue Solved/Closed
Hello, please give macro for hiding blank rows
-
EXCEL: Nested IF formula question Solved/Closed
Hello, I've read some answers to similar questions, but not quite the same... How can I have *certain* results of my nested "IF" formula display...
-
for my think.com password Solved/Closed
Hello, i forgot my think.com password . can any one help me
-
Simple Excel Question (I think) Solved/Closed
Hello, I am putting together an XL sheet and would like to find the MAX value in a column of numbers, then return the contents of the cell next to it...
-
VBA Excel Search Select Paste Delete Solved/Closed
Hello, If someone could possible help on this I would be very greatful. I have reems of data in Excel (tidal data). I'm looking to get the highs...
-
Auto_open Solved/Closed
Hello I have a question about Auto_open. Where do I put it in VB Editer? Do I put it in a Module, or Sheet, or Workbook. I have 3 sheets in the work...
-
forgot Password & secret question of orkut Solved/Closed
Hello, I m using new gmail & orkut A/c. But i forgot my ol orkut a/c's password & secret question. I want to delete my old a/c. Can anybody pls help...
-
Adding Dates Solved/Closed
Hello, I am trying to find a formula that calculates dates. Like I have two boxes with a beginning and date in them, and I want to calculate the day...
-
IF iserror with 2 cells match Solved/Closed
Hello, If i have 2 cell that i need to match to 2 array row and print "W" or "L" if both of the cell match. This is what i have =IF(ISERROR(M...
-
IF formula Solved/Closed
Hello, wondering if you can help me with excel i need a formula that shows if A1 is starts with letter then give me a that first letter. If it sta...
-
macro help...copying and pasteing Solved/Closed
Hello, I'm trying to write a macro to copy a row of cells to where the cursor is. The info is constant and the pasteing changes. I've used the "reco...
-
What is HDD (HP) Master Password? Solved/Closed
Hello, I have Windows XP and it's shut me out of me out. When I turn on it has black screen, asks for a DriveLock Password, a second I forget, then ...
-
VBA to Open an excel file in notepad Solved/Closed
Hello, Can someone tell me the vba code to open an .xls or .csv file in notepad? thanks PM
-
Conditional activation of macro button Solved/Closed
Hello, I was wondering if it is possible to only make a button work if there are only two cells selected. I have got a button which will copy th...
