Office Software Forum - solved topics
- Excel (9,794)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
- Solved
-
Delete certain cells of active row Solved/Closed
Hello, I would like a code for the following: Check which row is active/selected and then delete the data which is in the 5th and 7th column of ...
-
insert rows based on count of row in another Solved/Closed
Hello, I have a excel where I create few dummy accounts and the next sheet (sheet2) has details of these accounts. I need the sheet 2 to have certai...
-
last value in a row with diff. 25% on rel val Solved/Closed
This is tough to even state, but I'll try with an example Example: find the first value that changed 50% in relation to the last time when there wa...
-
colour Solved/Closed
Hello, Hi and thanks for previous help. Last one for a while (I hope) I am using the below formulae you gave me and it is fine. However these res...
-
Excel Macro - Dynamic Column Selection Solved/Closed
Hello, I am just beginning to learn Excel macros. I was working on a sheet wherein I have to select a column dynamically, based on just the column ...
-
Text box linked to cell value Solved/Closed
Hello, I have a text box placed in a chart that links to another sheet/cell for its content. The value is a percentage. I can format the source text ...
-
Dates Solved/Closed
Hello, Crazy question.... I have a row full of different dates. I would like to create a formula to display in a separate cell, the earliest date fr...
-
Separate required records from a file, MAK Solved/Closed
Hello, I am using following macro to separate required records from a file contain several worksheets and each worksheet contain thousands of rec...
-
Excel conditional formatting row color Solved/Closed
Hello, I am trying to get Excel to automatically change the color of a row depending on the entry in column H. I've got some VBA code written up, but...
-
MATCH formula with external lookup_array data Solved/Closed
Hello, I am trying to write a formula using the MATCH function =MATCH("x",r1:r10,0) to find the first instance of x in a column. Howev...
-
Copy Data One Sheet to Another Solved/Closed
Hello, dear friend i have two work sheet.first sheet has a data.using subtotal function I'm daily taking summary of that data.that summarized data da...
-
Macro to Compare two sheet with both sheets h Solved/Closed
Hello, I have a 2 excel sheet which has all the column having same. This has D$C Comment, OMS comments, Planned Resoluiton date & Sub account in bo...
-
Lookup,count and pie chart Excel2007 Solved/Closed
Hello, Can anyone give advice? I got a form on sheet1 thats got a savebutton to save the input data of the form to the database on sheet2.On sheet2 ...
-
scores Solved/Closed
Hello, Hi I will sonn get a sheet of student exam outputs listing there choice of answer from a to p for each question. I have a space st the top of...
-
how to match value with table Solved/Closed
Hello, I have a problem to match the value from sheet 2 with another sheet name table. I want to compare if the value near with the value in the tab...
-
Countif based on two criteria Solved/Closed
Hello, I'm tinkering with a spreadsheet I use for my business and would like to create a count of the number of products dispatched on a date. I ha...
-
Changing color of a cell in a table... Solved/Closed
Hello, I'm afraid that this post rather fits into the "free help" section of things here, I am a person with a basic knowledge of coding and i...
-
How to fill selected cells with given data? Solved/Closed
Hello, I often need to fill cells with a date of production. What kind of a macro would be usefull in this situation so that I could just select the...
-
Selectively Transfer Data toPre defined Range Solved/Closed
Hello, I am new to Excel VB. I'd like to compare a set of data from worksheet1 by meeting a set of multiple conditions/criterias and then transfer ...
-
Find a string in Excel and remove all cells Solved/Closed
Hello, I need to find a string (for example: abc) in a large worksheet then remove all cells containing this string. I have tried different functions...
-
Cut-paste row to sheet2 if columnvalue is met Solved/Closed
Hello, I have got 2 sheets. Sheet1 contains a list of assignments, in which column B contains the status of those assignments. Sheet2 contains comp...
-
Converting a number in words into a number Solved/Closed
Hello, i want to convert wrods into a number.Let me say more clearly... if i take " one thousand five hundred six " it should be converted into ...
-
column comparison Solved/Closed
Hello, i have two columns to confirm the name , I want 2 identitfy; do the first column name is same person in the weccond column for example...
-
Excel help Solved/Closed
Hello, I am having trouble with an excel calculation, i'd be grateful for any help: I have menu items listed along the top, with a space for th...
-
getting perfomance of each vendor using excel Solved/Closed
Hello, What I want is to get an evaluation of every supplier. Let say I have 20 list of supplier and list of product I'd ordered, including quantity...
-
Find a text in a sentence inside a cell Solved/Closed
Hello, I have a column which has addresses of different Companies, eg. SHRUTIVEER,23/2/1/1 BHAGBAN CHATTERJEE LANE,HOWRAH 711101 2nd Floor, Eas...
-
adminstrater password problems Solved/Closed
Hello, my 10 year old daughter changed her password on laptop on the admin user she cant remember her password .
-
copy a "Comment Text" in to "Cell T Solved/Closed
Hello, my Self Deepak Kumar, I can't find the fomula how do Copy a "Comment Text" in to "Cell Text" in another sheet. Regards Deepak Kuma...
-
Date Format TODAY Solved/Closed
Hello, I have an invoice with a date format "TODAY". If I create an invoice today, it assigns today's date. If I open the invoice tomorrow, it as...
-
Excel Forumla help (IF formula) Solved/Closed
Hello, I need some help, I just can't figure the IF formula out. On my Excel 2007 spreadsheet, I am trying to figure out if I put the letter grad...
-
formatting with more than 3 colors Solved/Closed
Hello, I need your help guys, i wanted to apply the formatting with more than 3 colors in my worksheet. The worksheet im working on has a lot o...
-
Conditional Formulat with #ous condiitions Solved/Closed
Hello, I have to write a formula to account for 6 conditions from 6 different columns. Originally, I thought it could be done by a simple nested I...
-
Law School Acceptance Chances Solved/Closed
Hello, I want to compare possible GPA and LSAT scores to Minimum Acceptance GPA and LSAT scores. I've tried using IF and AND functions, but I can't s...
-
counting Solved/Closed
Hello, I am trying to count the number of cell's from I4:I304 that have "no access" in it, but in those cells not only do some of them have "no acces...
-
excel macro loop to insert pics into more cel Solved/Closed
Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
-
EXCEL HELP combining info from2 sheets Solved/Closed
Hello, Hello, How can I match and combine records across two excel sheets. I have two excel sheets containing record information, about 6 columns f...
-
forget password & secret question Solved/Closed
Hello, i have forget password & secret question .please help me.please reset my passwrd . kamal nautiyaljubl@yahoo.co.in
-
forgot password of memorycard Solved/Closed
Hello, i forgot my password of my memorycard of nokia 3110c.. pl help me to change password.. thank u
-
Excel If Function over a range of dates Solved/Closed
Hello, Can anyone help please? I am trying to add a divisions column, which are taken from a date range in another column. i.e. I would like to add "...
-
INSERT AND ORDER THE COLUMN Solved/Closed
Hello, It has A, B, C, D, E Columns and less then 6500 rows as per given example. A and the B column are fixed. I want to reorder compare "C" co...
-
Add cells, div by cells with value (Excel2007 Solved/Closed
Hello,can any help!(excel 2007) A B C ...
-
Excel Formula to show Zero Solved/Closed
Hello, I'm using the formula =A2/(A2+A3) in A4, same in B to AF, i need the A4 line to show a zeros when A2-AF2 and A3-AF3 do not have values in. ...
-
compairing two columns A&B Solved/Closed
Hello, column A column B 5000 4001 5001 4080 5002 4445 5003 4493 5004 4...
-
Network Days Solved/Closed
Hello, I need some help if any one can assist, please... I have a date in a Excel S/S so i.e. 15/02/2010 and under this i have a number of days ...
-
Excel formula converting time difference Solved/Closed
Hello, i want to know the excel formula...below iam giving the details, In table A is my starting time e.g.10.49 and in table B is my reaching time...
-
deleting alternae rows Solved/Closed
Hello, I want to delete every alternate rows from my work sheet. I tried recording macro, but it only deletes a particular row as shown in macro bel...
-
Linking Spreadsheets Solved/Closed
Hello, I'm trying to set up a cell that will draw information from another spreadsheet using excel 2007 The spreadsheet I'm pulling the info fro...
-
Copy rows to total page Solved/Closed
Hello, I have an Excel spreadsheet with 13 worksheets. The first 12 worksheets are January through December. The 13th worksheet is a total. Each...
-
Creating a directional macro Solved/Closed
Hello, I am not familiar with writing macros at all. I created a form and I need a macro so that when I input data in a cell the cursor will automat...
-
Conditional Formatting or IF using Dates Solved/Closed
Hello, I am trying to change the colour of an entire row to 3 different states depending on the result. The row needs to stay clear if the date ...