Office Software Forum - solved topics
- Excel (9,853)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
- Solved
-
Excel Formula for Conditional Formatting Solved/Closed
Hello, I'm trying to find a formula and instructions for shading date values in a column on a worksheet based on the month relative to today's date. ...
-
set password in mozila firefox Solved/Closed
Hello, i want to know how can i set pass word in mozila firefox which is ask me when i start or open firefox. please repy or answer in my email addr...
-
Highlight one cell based on date in a range Solved/Closed
Hello, Using conditional formatting I wanted to highlight one cell based on a range. I wanted for example a1 text to be highlighted when one cell or...
-
Excel Date formatting problem Solved/Closed
So here's my problem. I have multipe dates all in one column on one tab/worksheet of an excel workbook. When I try to link to that date on another tab...
-
count a text string if criteria is found Solved/Closed
Hello, I have a problem and is that I want to count a text string from a range of cells, if the criteria is found correct, for example, jamshedpu...
-
please help with my spreadsheet Solved/Closed
Hello, I am having a hard time trying to figure out how to format my spreadsheet so that i can make it a template that i can use in future, this is w...
-
PLEASE HELP! EXCEL QUESTION Solved/Closed
Hello, I am trying to figure out how to count the number of cells that contain a certain text. For example: Column A 2007 Entry Draft ...
-
Simple function or formula I think Solved/Closed
Hello, I want to set up a formula or function to display a number from another cell only if a different cell is greater then 0. Example: data in Cel...
-
excel 2003 question Solved/Closed
Microsoft Office Excel 2003 I am trying to put in todays date along with text. How would i do this? in box A43 i have: =Q1&R1&S1 in Q1 i h...
-
Excel: Copy active range to bottom of list Solved/Closed
Hello, On multiple sheets I have lists of peoples names. When I add a few new names on one sheet, I want a macro to copy-paste these names to the o...
-
Adding data from one column using another Solved/Closed
Hello, I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together t...
-
COUNTIF Formula Solved/Closed
Hello, I have one excel file in that Colom "B" has the "pending or Closed" Status and Colom "C" has "Sevirity 1, Sevirity 2 and Sevirity 3" I wa...
-
To retrieve the particular cell value Solved/Closed
Hello, Can you please provide me with a macro VBA code In "Sheet1" i have values in 'A' and 'B' columns. Sheet1: A B 1 Name ...
-
Clear cell contents based on color Solved/Closed
Hello, I have a range of cells (E7:AI18) which I want to delete the contents of, if the color is white, gray-25% or gray-80%. So if cell E7 has ...
-
Vlookup - find value 3,4,5 etc.. Solved/Closed
Hello, I can use a vlookup to find the first and second value using True or False after the formula. However i would like to able to find more valu...
-
Hiding a cell if value equals X Solved/Closed
Hello, I want to do the following in EXCEL. I have a formula which works out the cost of one item at $35 plus adds $3.8 per item thereafter. Tf ...
-
VBA underscore trouble Solved/Closed
Hello, I wrote a simple VBA code which is pretty long, so I want to use a underscore to continue on the next line. Here is an example of the cod...
-
Access database restarts computer Solved/Closed
Hello, I have an Access 2003 split database that I have been working on for some time now and today when I go to open it my computer does a restart, ...
-
“False” result not working on IF formula Solved/Closed
Hello, This is the formula: =IF(Z2>=TIME(11|59|0)|"Afternoon"|"Morning") The contents in cell Z2 is 10:31:30. I was hoping my formula result w...
-
VBA: Error 9; subscript is out of reach Solved/Closed
Hello, Depending on the value of a specific cell (sheet "gegevensblad" cell L10), I would like to hide 1 out of 2 sheets (Either Overzichtsgrafieke...
-
list month from any given year in excel Solved/Closed
Hello, i 0got a spreadsheet (data) as below date status 1-jan-1975 approved 1-feb-1980 suspended 5-mar-1985 rejected 10...
-
Activating Macro Solved/Closed
Hello, I have made a calender which I want to prepare for next year with the press of a button. Here is the file: https://authentification.site...
-
Require help in excel Solved/Closed
Hello, Pls help me by suggesting any formula or function for selecting two minimum values from range of numbers in excel spreadsheet. For exampl...
-
Trouble activating macro Solved/Closed
Hello, I've got a macro which runs on 12 worksheets. When the result of a formula changes I want the macro to do his job. What I do now is manu...
-
Conditional formating for entire rows Solved/Closed
Hello, First I would like to thank Aquarelle for her kind words, regarding asking questions. I'm working on a calender where each day has a diff...
-
install ms office 2003 Solved/Closed
Hello, My name Am from Cambodia. I'm studying the Information of Technology of year 2 at a private university in Siem Reap-Angkor. I wonder"how can I...
-
Excel worksheet help Solved/Closed
Hello, So i've tried like hell to figure this out but have no programming skills at all. I have basic excel experience most of it self taugh or what...
-
excel 2007 timeline, help please Solved/Closed
Hello, timeline, help please im looking for a formula to fill in a cell with either s,p,v or h depending on data taken from sheet 2. the data...
-
Possible to extract partial data in Excel? Solved/Closed
Hello, I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. http://www.frogs.com/. W...
-
Excel Formular Problem Solved/Closed
Hello, =IF(B2=1,"Entertainment","") I have this formular which when i type a value into one colume it will display text in another and the end o...
-
Macro to find last blank cell in column Solved/Closed
Hello, Can anyone help me with this please? I want a macro to run in Excel to do the following: 1. Go to a column and working from the top down fin...
-
Excel Total Range of Values Solved/Closed
Hello, I'm trying to get a range of values totalled. I have one set of columns, lets say column A1 to A200, ranging from -30 up to 1000 and another ...
-
Calculate the sum of rows using macro Solved/Closed
Hello, I need some help with the folowing problem. I have a table with changing length of rows and columns. I need to calculate the sums of the rows ...
-
My Replies are not appearing Solved/Closed
Hello, I"m giving replies in Office Software Section but my replies are not appearing. May be some problem in Site????????
-
above cell Solved/Closed
I get a large database every week in which I have to insert a row every row different than the one above, it is a tedeous task that takes me hours, I'...
-
Excel Column Sort Solved/Closed
Hello, i have a list of numbers/letters titles written like: 1KFLS921 there are around 2000 of these listed down column A. i have the same l...
-
Microsoft Office ? Solved/Closed
Hello, Does Microsoft Office work on Windows Vista ?
-
Excel - reset / replace seconds to zero Solved/Closed
Hello, i have an Excel 2007 file which has in sheet1 the time people enter to the system with the format ex. 11:55:31 AM and i need to reset all the ...
-
Send value of cell to target Solved/Closed
Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value chang...
-
excell Macro Help Required Solved/Closed
Hello, I have 3 Excell Workbooks, i need to create a master sheet, but when ever i update the master sheet the data updated shouls reflect in all t...
-
Need help in Excel Macro Solved/Closed
Hello Ivan, Ive' been reading a lot of your answers and i'm quite facinated of your skill. I need to create a macro for one of my project and it i...
-
Excel Help Solved/Closed
Hello, Ok am not that experienced with excel, so if any one can helo would be great. I have a huge spreadsheet and i am constantly updating it. ...
-
Having Excel IF formulas print text and calc Solved/Closed
Hello, I am trying to get Excel IF formulas to print text and calculation based on true/false. Such as, if I have some dates, and I don't need to s...
-
need for dfd Solved/Closed
Hello, i am devendra mishra i am working on project hospital management i am not getting the dfd(data flow diagram) of the project so pl...
-
what is my email server address? Solved/Closed
Hello, just trying to set up outlook express for the first time. i bought an iphone and the only way (im told) to save / sync my contacts information...
-
Ms-word asks for converter Solved/Closed
Hello, I have some Ms-word files of 2003..But every time upload the system with Vista i cannot read my saved word documents..it continusely asks f...
-
Count and summarise records in Excel 2003 Solved/Closed
Hello, Sorry to bother you but I have a minor problem with a spreadsheet and I don't know how to resolve the issue or whether it is possible u...
-
Create Msg/Popup to notify in Excel VBA Solved/Closed
Hello, I need a Excel VB script to notify/popup a message when the number of the letter U on a calendar exceeds 6, 8, 12 etc. It will have to check...
-
converting date format in excel sheet Solved/Closed
Hello, I have a cell which contains date in the format dd/mm/yyyy, but i need to convert to mm/dd/yyyy in excel how can i do this?
-
help to find Solved/Closed
Hello, can any one tell me how to find my outlook express on my computer so i can get a email thats in it.thank.
