The discussions

How to count the number of occurrences in a range

I would like to know how to count the number of occurrences of each number in a range. Example would be, how many times each number from 1 thru 50 occ...

3 replies Last reply on 17 Oct 2017 by
Mazzaropi

Formula for unique id's following a predefined rule

Hi, I am in need of a formula that can deal with the following situation: We have many projects each year. Each new project gets assigned a 4 d...

1 reply Last reply on 16 Oct 2017 by
TrowaD

Dates conversion

Hello, How do i convert dd/mm/yyyy to mm/dd/yyyy for this date 05/10/2017 into 10/05/2017? this formula (MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A...

1 reply Last reply on 16 Oct 2017 by
TrowaD

Reformat date field to plain text

I have access to a spreadsheet posted on the Web. I have copied it and pasted it into a MS Excel 2010 spreadsheet. There is a column that I would ap...

1 reply Last reply on 15 Oct 2017 by
vcoolio

How to find a product key for ms office 2010?

 Closed

HOW CAN I GET PRODUCT KEY OF MICROSOFT OFFICE 2010?

Last reply on 15 Oct 2017 by
Ambucias

How to give a students two ranks

Dear sir, I have made a result sheet with ranks. I want to give a student two ranks one in his class and other in all sections. For example, if class ...

4 replies Last reply on 13 Oct 2017 by
Fayyaz295

Delete or insert rows in a workbook

 Solved

Hello, sir how i can delete or insert rows in a workbook between sheet one & sheet two for example when i insert or delete row in sheet one i wa...

1 reply Last reply on 12 Oct 2017 by
TrowaD

How to make one summary file with 29 sum up sheets

Hi My self Dr. Seema Mehrotra working as an Urban Economist at National Institute of Urban Affairs, New Delhi, India. I am working on a very large...

1 reply Last reply on 11 Oct 2017 by
ac3mark

How to insert reading progress indicator in microsoft word .docx

Hello, I use Word 2016. How do I insert 'Reading Progress Indicator / bar' in my .docx documents?

1 reply Last reply on 10 Oct 2017 by
ac3mark

Autopopulate using dates

Kind of a complicated one. I'll be appreciative/extremely impressed if someone can help me out. I'm budgeting and trying to autopopulate cells usi...

1 reply Last reply on 10 Oct 2017 by
TrowaD

How do i create this conditional formula

How do I create this formula? If A2, B2, and C2 has a combination of H, H, HP (it doesn't matter what order it is in), returns a score of 98 in cell ...

2 replies Last reply on 10 Oct 2017 by
TrowaD

What formula can be used to share data in 2 sheets

Hello, I have two excel sheets A and B having the same columns. there names, dates, figures. not necessarily having the same number of rows, havin...

1 reply Last reply on 10 Oct 2017 by
TrowaD

Conditional formatting

I wondered if you could assist please? I currently have a column of dates that change to a bold red if the date is past. However, I require the date...

1 reply Last reply on 10 Oct 2017 by
Mazzaropi

How to use a macro to check data in 2 work sheets

 Solved

Hi team I have 2 work sheets with thousands of data. I need a macro to compare data in these 2 work sheets and show the result(matching or not matc...

1 reply Last reply on 9 Oct 2017 by
ac3mark

Can't send messages in outlook 2010

I cannt sending my massages from outlook2010 but I revived very well

1 reply Last reply on 9 Oct 2017 by
Ambucias

How to generate a static unique identifier for each excel row

 Solved

Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...

4 replies Last reply on 6 Oct 2017 by
ac3mark

Two if forumlas inside an if formula

 Solved

Hello, I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree! ...

4 replies Last reply on 6 Oct 2017 by
Mazzaropi

Formula with varying information need pasted multiple times

Hello, I have what may be a simple issue. I have a spreadsheet that I need to apply a formula to in certain fields. One formula may need to be =...

1 reply Last reply on 5 Oct 2017 by
ac3mark

Master sheet to affect multiple sheets

Hello, I am not sure how to explain this... I have a master sheet that has a list of all the names and grades for each row alphabetically. I have ...

1 reply Last reply on 5 Oct 2017 by
vcoolio

How to find grade

How find grade in excel, old tell me about the formula

1 reply Last reply on 5 Oct 2017 by
xpcman

Autopopulating multiple sheets from one main sheet

 Solved/Closed

Hello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...

Last reply on 5 Oct 2017 by
TrowaD

How to sum a number from a range of cells, based on value

 Solved

Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....

3 replies Last reply on 5 Oct 2017 by
TrowaD

Subtracting numbers based on data in another cell

I use a cell to show that a number has been deducted from an account. How can I make a subtraction of that amount form a total amount based on the inp...

1 reply Last reply on 4 Oct 2017 by
ac3mark

Name check

Hello, How to check the name with two cells. if any part name matched with second cell, it have to be show as TRUE. What formula for this?

1 reply Last reply on 4 Oct 2017 by
Mazzaropi

Self-generating sequenced number each time a sheet is opened

How do you create a ( for example an invoice) self-generating sequencing number so every time an excel sheet is opened it will generate the new number...

1 reply Last reply on 3 Oct 2017 by
ac3mark

Rank of numbers between specified range

 Solved

Hello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...

3 replies Last reply on 2 Oct 2017 by
TrowaD

Paste x times with multiple conditions

Hello, I have no real knowledge of macro, but I think macro has a solution to my question I have data in Sheet1 and would like output in Shee...

2 replies Last reply on 1 Oct 2017 by
anshul1233

Microsoft office 2013

Hello Dears, I have dawnloaded microsoft office 10 for windows 7. But, I couldn't install because I do not have product key. Would you please he...

1 reply Last reply on 30 Sep 2017 by
Ambucias

Formatting cells based on certain criteria

 Solved

I want to make a cell change colour based on a number of different criteria: Cell A1 Has an incident date B1 Displays the date 14 days after the inc...

7 replies Last reply on 29 Sep 2017 by
sailingdemon

New tab copy paste

Hello, Being extremely new to VBA I am trying to create a macro that Creates a new worksheet and then have it copy and paste data into the new works...

1 reply Last reply on 29 Sep 2017 by
ac3mark

Save as in a macro

Hi i am trying to save a copy of my workbook ie p&l report plus the date so i can save it each week, so far the macro i have will print all info and c...

4 replies Last reply on 29 Sep 2017 by
ac3mark

Microsoft windows 10 error saving pdfs on a usb drive

Hi, I have had only problems and huge wasting of time since I installed MS Windows 10. Along with everyone I have spoken to, we are all utter...

3 replies Last reply on 28 Sep 2017 by
Ambucias

Creating macro for auto updating multiple workbooks

Hello, I have been assigned a daunting task to create multiple reports(5) for specific clients in one workbook. This project is large as there ar...

4 replies Last reply on 27 Sep 2017 by
ac3mark

Microsoft office home 2010 did not got the product key

 Closed

Hello, I'd downloaded Microsoft office home and business 2010 but i did not got the product key. please help me. Windows / Firefox 55.0

Last reply on 27 Sep 2017 by
xpcman

Need help with a macro that can copy and paste last 10 active da

Hey Guys, I am a newbie to these Macros. I need desperate help from the EXPERTs. A few things I need for my macro are: 1. I have multiple d...

1 reply Last reply on 26 Sep 2017 by
ac3mark

Attendance log help

Hello, I have an attendance workbook I am working on and need to make different worksheets according to age. I have everything entered into the fi...

1 reply Last reply on 26 Sep 2017 by
ac3mark

Copy paste rows from one sheet to another n times.

Hello, I need help with Macros. I have my primary data(seeking production schedule) on sheet 1. I will have 100-120 rows Of data. Column A(no of ...

1 reply Last reply on 26 Sep 2017 by
ac3mark

Find matching data in two worksheets and copy entire row

I have one sheet that has about 350k rows and columns A-AW. Column Z contains phone numbers. I have a second sheet that only has phone numbers (about ...

1 reply Last reply on 25 Sep 2017 by
vcoolio

Product key

i just downloaded Microsoft office 2010 and i can not locate the product key

1 reply Last reply on 25 Sep 2017 by
Ambucias

Sum ifs function

 Solved

Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a co...

2 replies Last reply on 25 Sep 2017 by
dshaviv

How to remove small squared on word?

Hello, Started to do a word document and page has small squares. Clicked on blank page, no change. Advise? System Configuration: Windows / Inte...

1 reply Last reply on 24 Sep 2017 by
Ambucias

Excel macro: copy formulas across worksheets

 Solved

So first off, I have no Idea how to program, but I can kind of understand simple programs. Either way, I'm trying to figure out a macro in MS Excel...

12 replies Last reply on 24 Sep 2017 by
OCG

How to get b column value against a column

Hello I have 3 columns like A B C D 1 2 5 2 5 4 3 9 2 4 8 1 5 7 3 Now I Will Compare A And C Column...How To Get B Column Value...

1 reply Last reply on 22 Sep 2017 by
ac3mark

Formula search keywords in multiple columns

Hello, I need to find a excel formula (column A) to track keywords in a table with multiple columns. the key words are for example Accor F...

1 reply Last reply on 22 Sep 2017 by
ac3mark

Help : copy paste to end of list without formatting

Hello everyone :) System Configuration: Macintosh / Chrome 60.0.3112.113 I'm new to Macros in Excel so I really need some help. Basically I ...

3 replies Last reply on 22 Sep 2017 by
ac3mark

Enter value in cell, have range of cells copied to another sheet

Hello, I have an materials list spread sheet that when I order a line/row, I'd like that row with the amount ordered to transfer to blank sheet 2. ...

1 reply Last reply on 22 Sep 2017 by
vcoolio

How to do a macro in excel with random pics?

I need to do a macro with random pics. When in column "K" in scheet "SHEE4" find word "OK" then replace or paste in next cell random image from folde...

1 reply Last reply on 20 Sep 2017 by
ac3mark

Arrow keys scrolling in excel

 Solved/Closed

Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do not...

Last reply on 20 Sep 2017 by
Upthewall

Product key

How can i get product key?

1 reply Last reply on 20 Sep 2017 by
BunoCS

Help with formula please

 Solved

Hi, please could someone help me with a formula to add up cells that have data in them. My spreadsheet has data in columns B-N - some of them have ...

3 replies Last reply on 19 Sep 2017 by
CB7373
Results 1051 - 1100 out of a total of 12,266