The discussions
Excel pro
Solvedhi , 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
SolvedHi, 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
Solvedhi, someone has stolen my email password.. and iam not able to get it back. how should i get it back?
Memory card password
Solved/ClosedHello, 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
SolvedHello, 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
SolvedHi, 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
SolvedI 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
SolvedI 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
SolvedOK, 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
SolvedHi! 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
SolvedHello, 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
SolvedHi There, I would appreciate, if anyone could help me with the following. Item Qty Length Supp1 Supp2 Supp3.......Supplier7 A ...
Copy with lookup
SolvedHi, 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
Solvedi 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
SolvedHello, 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
SolvedHello, 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
SolvedI have some columns of data looking somewhat like this: data1...data2...data3 val.........val........val val.........val........val val............
Need help on vlookup
SolvedI 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
SolvedHello, 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
SolvedI'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
SolvedDepartment | 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
SolvedHi, 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
SolvedHello,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
SolvedHello, 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
SolvedI 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
SolvedHello, 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
SolvedHello, 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
SolvedHi 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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?
SolvedHello, 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
SolvedHello, 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...
Date formatting
SolvedHello, I am currently downloading a report from an external source (csv file format) into excel and one of the fields (column P) should be represen...
Excel
SolvedHello, I have an excel file with Start dates, end dates, total day, and networkdays columns. I would like to average these number for the average to...
For each cell... vb help
SolvedHello, Column A contains either "Ja" (yes), "Nee" (no) or nothing. I would like to know on which date the cell value is changed to "Ja". Therefor...
F 5 problem
SolvedHello, Up untill yesterday, when I used F 5, the cell that I was going to always ended up in the upper left corner of the screen. Now it goes to so...
Ms words into (comma-separated) text file
SolvedHello, What I try to do is that convert multiple MS forms into tab-delimited text files. If there is a quick and dirty way to do so, please let me ...
Need help with a formula please!!!!!
SolvedHello, I and creating a spreed sheet for my job to make weekly counts easier. I have been trying for hours now on a formula to calculate either a...
Problem with "lastline" in vba excel 200
SolvedHello, Let me start off by saying that I'm a VBA noob, and have never worked in it before. Basically, I inherited a spreadsheet which has a macro t...
Changing h:mm am/pm to hhmmss
SolvedHello, I need help changing imported times from i.e. 2:38 PM to 143800 (hhmmss). Please Help!! Thanks, icooper
Moving the contents one cell up in a column
SolvedHello, In my excel sheet the column C has contents in alternate cells starting from C1 till end. It looks like C 1 ...
Formula to copy data
SolvedHello, I have a range table that is 18 columns. I want to be able to look up the number in the first column and return all the info in the other 17 ...
If statments w/ <= dates
SolvedHello, Hello Want a brain buster? Its been busting mine all day…… I'm trying to create a statement for column J "frequancy of visit" to ret...
