Office Software Forum - solved topics
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
- Solved
-
Changing a value using a look-up table Solved/Closed
Hello, I am looking for help on writing a macro that will perform a VLOOKUP formula that will compare the value in G2 on Sheet1, to the value in A...
-
copying % formula Solved/Closed
Hi, I regularly calculate a series of number as a percentage of a sum that remains constant (expense item as a percentage of total expenses, for eg.) ...
-
Help on Excel Formula Solved/Closed
I need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a...
-
Comparing Column Values Solved/Closed
I am trying to compare two columns to see if they carry the same values - column A has 556 values (starling at line 3), and column B has 69 values (st...
-
2+2=5 Solved/Closed
can u prove it with littel mistake in mathematics.
-
Identify two or more are same or not in Excel Solved/Closed
Hi Everyone, I have an excel formula question that someone might can help me with. A B 1
-
Count 2 values in one column and 1 val in oth Solved/Closed
Hello, I have two column lists (two values in first column and one value in the other) e.g. Column A has the following values: A B C B B A C ...
-
Moving Data Solved/Closed
Is there any one who can kindly come to my rescue!! I have been presented with date in the form: A B C D E F G H I J ? My aim is to pre...
-
match a string to a col & increment by 1 Solved/Closed
I have two sheets with data as follows: Sheet 1 String, result A0101 Format of string in Sheet 1 column A: Axxxx (A - alphabet a to z, x num...
-
how to convert a numberic valu in to english Solved/Closed
how to convert a numberic valu in to english
-
merge rows of similar data Solved/Closed
Hi, I am trying to merge various rows of data with a common headin in Column A. For example I have the following data: A 1 0 0 0 1 B 1 1 0 0 ...
-
excel pro Solved/Closed
hi , i have some data like gvn below M/C SR NO. total b4 a4 cl4 k92661400 18632 8544 544 9544 K81667500 21844 18948 1948 948 H25102020 6756 8...
-
Filter duplicate entry with condition w excel Solved/Closed
Hi, I've 2 columns of data. Column A are repeated Test sequence and Column B are Status (OK / Fail). I would like to extract those test sequence wi...
-
someone has stolen my password Solved/Closed
hi, someone has stolen my email password.. and iam not able to get it back. how should i get it back?
-
memory card password Solved/Closed
Hello, i have nokia 3110c and I had put a password for the memory card and now I have forgotten the password so if u can help me thank ...
-
Changing cell ranges in all series of a graph Solved/Closed
Hello, I have a graph with 5 series on it. ='Entire series of data'!$E$17,'Entire series of data'!$E$5066:$E$6375,'Entire series of data'!$I$17...
-
Find Max Valu every 10 rows &mark row as keep Solved/Closed
Hi, I need help creating a formula in excel to Identify the Highest and Lowest values Every 10 rows THEN Identify those two rows...
-
Compare numbers in two columns in Excel Solved/Closed
I appreciate any response to help me with this. I have two columns of numbers A B B.121 S.222 S.154 B.121 B.164 ...
-
Keeping only specfic text in a cell Solved/Closed
I have an excel file that has data dumped from external source (P6). One cell contains a lot of data of which I only need very specific. Here is wha...
-
Excel Macro - using integers as cell referenc Solved/Closed
OK, I've written this and I'm having some trouble. I've put the comments in the code (preceded by ****) rather than giving you a summary here. I thi...
-
Excel: Need Macro to run when value entered Solved/Closed
Hi! It's been a long time since I used VB. I seem to be a bit rusty, and I can't figure this out. What I need is for a specific macro to run when...
-
Macro to Deleting Multiple Rows Solved/Closed
Hello, I am running a simple formula in excel to sort out duplicates from a given row, by adding the value "DUP" in a new column on the spreadsheet. ...
-
Select by lowest cell value & group by column Solved/Closed
Hi There, I would appreciate, if anyone could help me with the following. Item Qty Length Supp1 Supp2 Supp3.......Supplier7 A ...
-
Copy with lookup Solved/Closed
Hi, I am working with 2 Excel, One field is common in both the excel "SID". I need to copy the row of SID say 'ABC' from Excel B and append to the ...
-
microsoft word Solved/Closed
i have a old microsoft word dosc i cant remember the serial # for how do i go about finding it on the program?
-
Win messenger my secret answer or my password Solved/Closed
Hello, i need to get in my windows messanger but i forgot my password and my secret answer. It is very important for me to get in there right n...
-
how to remove password of my micro memory car Solved/Closed
Hello, i m V andana. i forget my memory card password .my phone is nokia 5130. and i have sd micro memory card of !GB.i want data from memory card p...
-
extracting data from specified columns Solved/Closed
I have some columns of data looking somewhat like this: data1...data2...data3 val.........val........val val.........val........val val............
-
Need help on VLOOKUP Solved/Closed
I have list of Incident numbers(both Closed and open) in Cloumn A and only open incident numbers in column B. I should be able to filter the rows base...
-
forget skype password Solved/Closed
Hello, my skype password has changed by someone how i open my accountConfiguration: Windows XP Internet Explorer 8.0
-
Need help on an excel if/then in Macro Solved/Closed
I'm trying to create an If/Then in Macro for a cell which you input what GPM you want to use. The goal is to stop sales people from making errors and ...
-
VB for split data Solved/Closed
Department | Name | Amount Spent | In my file, there's one column specified different departments of a company, with their money spent by the peo...
-
Copy down formula if cells on left non blank Solved/Closed
Hi, I need code to copy down a formula from R2 to R3, R4 , R5 etc only if H3, H4, H5 etc is nonblank. I also need to copy formulae from U2:CY2...
-
Lookup/Identify next number,Paste into cell Solved/Closed
Hello,I need help with a identifying the next number! When pressing the Save button on sheet1-Form(Code below),lookup the last number that was used...
-
repeat formula Solved/Closed
Hello, I need the the formula to work for every cell in column A. So if I select A1 and enter a number >= 40 it skips the next cell, and if I select ...
-
Compare two columns and delete duplicates Solved/Closed
I have a large amount of data that is supposed to be unique based on two columns (Column A, Column B). The combination of these two columns are not s...
-
Compare 3 Columns excel Solved/Closed
Hello, I have to compare 3 columns (A,B AND C) filled with names and return, in another column (E), the list adding the names from the 3 columns (...
-
Help Need writing a formula Please Solved/Closed
Hello, I have a report I pull which outputs IDs. There are 5 IDs. Management would like to display their respective Site locations instead of the IDs...
-
Excel Macro to group by column & sum value Solved/Closed
Hi there, I need to write a macro for following example. Item Qty Length A 1 100 A 1 100 B 2 200 B 1 100 B 5 100 C 4 200 C 2 100 C...
-
Adding Cells Solved/Closed
Hello, I am trying to build a macro that allows me to input a number on Sheet1 and then on Sheet2, add that number of Cells. Example. Sheet1 ...
-
Help with Excel percentages Solved/Closed
Hello, Please bear with me as I a very new to this type of syntax with that said here we go. I have four date columns in Excel like so: P...
-
Convert active excel wksht to pdf file Solved/Closed
Hello, I'm trying to figure out how to create a macro to save an range selected in an active worksheet and save to a pdf file by clicking an inserted...
-
figuring a number based on a percentage incre Solved/Closed
Hello, if i have a number and want a formula to know that it is a percentage of another number, what is the formula in EXCEL? i.e. if i have a s...
-
assign Macro to all yellow highlighted cells Solved/Closed
Hello, I am in currently in a pickle ... I hope all the masters could lend a hand to this VBA noob... Right now i wrote a macro to copy all formula ...
-
Excel VBA Msg Box when cell meets criteria Solved/Closed
Hello, Hi this will probably be very simple for someome however I am having a nightmare day, all I want is a vba formual which will bring up a mess...
-
forgeten my password Solved/Closed
Hello, hi could u please help me to found my alternate email address and to found my password too because they have steal my password and i can...
-
forgot password Solved/Closed
Hello, i forgot my password in facebook. The problem is that the e-mail adress in google is different from e-mail adress of the facebook. Please help.
-
Excel page linking Solved/Closed
Hello, I'm trying to link 5 pages which each have a total amount on, I am looking to put all the totals automatically on one page, what i am asking i...
-
How to make formula in excel cell for time? Solved/Closed
Hello, I want to make spread sheet with time in the Excel CELL How to do that? For example 1st cell should show 11hrs.56mins.05sec and next cell I ...
-
Marco to delete cells containing an interger Solved/Closed
Hello, I am stuck and would love some help. I have two Columns in Excel J and K. The two Columns contain numbers from 1 to 53. I would like to...
