1
vote
3answers
36 views

In Excel, How can I count duplicate names in one cell once, if they are attributed to another name

How can I count duplicate names in one cell once, if they are attributed to another name in another cell. One column A contains teachers names and column B contains student names. I need to know how ...
-1
votes
1answer
36 views

how can I sum hours in excel

I have a sheet with names, that appear up to 20-30 times in the column. Every name has in another column a time related, meaning work hours. I want to sum those hours, for every name particularly. SO ...
0
votes
1answer
9 views

I want a shortcut in Excel to cells I have Hyperlinked

I've built a Series of Cells which wnen concateneted = HyperLink to a remote server. Excel Wk Sheet 2010 (File name changes Daily with date function or Date User inputs) On the same Sheet I want to ...
0
votes
1answer
56 views

How do I merge data from other excel files to one master excel worksheet?

I have an uniform ID system throughout all the files, except with multiple entries and differing data named columns. I would like to create a master excel sheet with specific data columns from each ...
-1
votes
1answer
17 views

Excel column locking

How do you lock individual columns in Excel? I can lock an entire row but not indiviual columns. There must be a way to lock individual rows, but I cannot figure out how. Please advise.
0
votes
1answer
71 views

Automatically Updating a cell in Excel from another sheet's data, based on another cell's value

So, I have setup a drop down menu with a list of names in A1. What I want to happen, is have the Data in F34 change based on what A1 is reading. I want to have F34 update with data from another sheet. ...
0
votes
0answers
25 views

How to search comma separated tags in Excel and get results in a column. [duplicate]

I'm trying to tag items in a spreadsheet, and search through them, in a similar way to Nusantara How to Label / Tag Items in a Spreadsheet I've followed Excellll's brilliant advice and managed to get ...
0
votes
1answer
34 views

Pivot Table Charts excel 2010

I have a selection of data that shows scores for a group by score 1-10 is it possible to create two charts in one, one that shows the value of the scores in a bar chart and the 2nd that shows the ...
1
vote
1answer
34 views

VBA change Script on multiple tables

Via this forum I found a way to refresh autofilters in a table automatically after the data in a excel worksheet has changed, using this VBA script: Private Sub Worksheet_Change(ByVal Target As ...
0
votes
1answer
83 views

Coloring separate rows based on matching of data in key cell

i have a excel file as i want change the sheet that after sort on key column(MasterID), any rows same as key column change color to similar. for example
-2
votes
1answer
30 views

attendance software in excel [duplicate]

I want to make an attendance sheet in excel. If a child is present, the teacher will write ‘P’ in a cell or ‘A’ for absent.I have to add ‘l’ (which indicate late comer) also with attendance.So 'P' ...
0
votes
2answers
528 views

Excel: DD/MM/YYYY stored as text…need to convert to Date format

I have a slight problem. It would be easier to post an image but I can't because I don't have 10 reputation. Anyway I have a column with the heading "Birth Date", and dates entered in DD/MM/YYYY ...
0
votes
1answer
27 views

How do I copy data to another sheet over multiple columns?

I have a 2 sheet Excel book. The first sheet has a number of columns,filled with data including 2 columns with peoples names (surnames and Christian names). The second sheet has 6 columns in which I ...
-1
votes
2answers
127 views

Spreadsheet for Daily Equipment Hours

My goal on this is to keep track of equipment hours and have a daily report to reflect total hours and run time. I want to make a file with 31 days of worksheets in the workbook for the complete ...
0
votes
1answer
168 views

Excel: identifying if all values in a row are not equal

I am comparing setting files between devices and have loaded all the settings into an excel sheet. I want to see if any setting is deviating between the devices. Example: Setting1: ok ok ok ok ...
0
votes
0answers
111 views

select options from a drop down list multiple times in excel 2013

I have a drop down list that has Option 1, Option 2, Option 3 etc. when I select an option it populates all the information into another worksheet. the second worksheet is listed with days of the ...
0
votes
0answers
213 views

Scroll Lock key on for keyboard lights but off for Excel

My keyboard uses the Scroll Lock key to turn the lights for the keys and key background on and off. Excel uses the same key to control movement when using the arrow keys. How can I "tell" Excel the ...
0
votes
2answers
360 views

How to format excel cells that show duration in years and months?

I can't figure out how to do custom formating that would format input "1/5" as "1 year, 5 months", or "5,0" as "5 years". I do want the cell to retain original input of "1/5" but visually display "1 ...
0
votes
0answers
525 views

Can't choose “rows to repeat at the top” in excel page setup menu

I purchased a brother dcp-8150 printer and now when i'm in office 2007 excel file my "rows to repeat at the top" option in page setup cannot be highlighted. Can you help
0
votes
0answers
41 views

In MS Excel 2007,IF functions or AND funciton

Per FUEL Conversion Bracket <35% 35.01 to 40.00 40.01 to 44.99 >45% < 76% 0 10 15 20 >76.01 % < 80.99% 25 ...
0
votes
0answers
25 views

How to Label / Tag Items in a Spreadsheet and get results in column

I want to tag items in a spreadsheet for similar reasons to nusantara in his question of 27 Mar 12 (see How to Label / Tag Items in a Spreadsheet). I have followed the excellent instructions given by ...
0
votes
1answer
31 views

VLOOKUP Excel formula for multiple colums

I have two columns "A" and "C" containing names of people. Columns "B" and "D" contain their birth dates. How can I make 1 data validation table for columns A & C without having to make them in ...
0
votes
0answers
26 views

Excel Form Creation

i am creating a form in excel but want for the words to end at page margin and continue to next cell. i have word wrap off and the cells within margins are merged. I am new to Excel and need some ...
0
votes
2answers
79 views

How can I filter data based on items in a list?

How can I filter entries containing any specific word in a list of words? For example, I have a list of road names in Singapore. Amoy Street, Singapore Ann Siang Hill Anson Road Arab Street Armenian ...
0
votes
1answer
40 views

How to filter an array of words in Microsoft Excel? [duplicate]

How do I filter an array of words in Microsoft Excel? For example, I have a big list of road names in Singapore and I wish to filter all entries in the Excel containing any road name in the list. How ...
0
votes
1answer
468 views

Use 'if' to check a condition. If condition is not met, then do not change the value in the cell. Keep the previous value as it is

Cell B1 has value 1 Cell B2 has value 1 Cell B10 has no value. I write 'if' formula: B10 = if(b2=b1, b2,) The value in B10 changes to 1. Now, I change B2 value to 2. The cell B10 changes to 0. ...
0
votes
0answers
40 views

Combine columns from Excel files into one column

I have numerous files with "Visit Date" across all the files and I want to combine all these "Visit Dates" into one sheet with minimal human intervention. The files get updated as I type, and I need ...
-2
votes
1answer
24 views

In Excel 2007, what does the Header Row check box do to the worksheet

when do I use the header row check box in Excel when working with tables
-1
votes
3answers
354 views

Microsoft Excel. Inserting a common thing to entire row/column

I'm encountering a basic problem with excel and outlook. Please give it a thought. I have a list of phone numbers on excel sheet as well as outlook. It's just one column. All I need to do is insert ...
2
votes
1answer
56 views

Using Conditional formatting

how can i highlight a cell to show that range of cells in a row has no data I have tried the conditional formatting eg answer in cell AL, for range = L2 to AK2 using isblank but i cant get it to ...
1
vote
0answers
45 views

Excel opens previous revision of file for a specific user

I have a user that opens an Excel file on the network and gets an older revision of the file. Everone else can open the file fine. this user received a new computer and new version of Excel (2010) ...
3
votes
1answer
325 views

Need to paste a column from excel into powerpoint- how to paste so they are individual slides, not one

I have a column of 50 in excel 2003. I want to paste it into powerpoint but it continues to paste as 1 whole text box. I need 50 individual text boxes. Is this possible?
0
votes
1answer
28 views

Questionaire Restrictions MS Excel

I have a 10 question questionnaire. I want to restrict the answer to one box chosen with an "X". I have already coded the "X" input restrictions via DATA VALIDATION. Now I need to restrict the # of ...
0
votes
1answer
102 views

Unintelligible result opening csv in excel

When I open a .csv file in excel this is what is showing up: Maxtor Encryption ver 2.0.1.1.0 ³§o rkDV’)cÿA®T7B‡LôŠì£\% i¼r1 ØÕë—„×½é¿wjd ´Íâ¿…Öö?HÐ)vM!W«Va<žÒ LåRpµI©ô ...
0
votes
1answer
361 views

Excel 2010 Formula Bar - autofit?

In Excel 2003, the formula bar would autofit the height of the active cell. In Excel 2010, this doesn't happen. Is there a way to revert the behavior to the Excel 2003 functionality without trying ...
1
vote
1answer
85 views

Exporting Data into a form type format from Microsoft Access query to Microsoft Excel Worksheet

Thanks for any help you can provide. I would prefer not to use VBA if possible, but will if necessary. I have MS Office 2007. I have a query which holds information for products that need user ...
0
votes
1answer
269 views

Microsoft Excel value lookup, return result in an undefined number of row above

I know how to use the vlookup function to search my worksheet to return the value. However, what if the value that I want is in an undefined number of row above. Example below, if I were to search ...
0
votes
1answer
240 views

Unable to add, create, or remove drop downs on an Excel 2003 spreadsheet

In Excel 2003 the Validation option under Tools is grayed out for a specific workbook. The sheet is not locked or protected, but it is shared. Even the author of the sheet has the Validation grayed ...
3
votes
2answers
82 views

Excel cell formatting

I want to insert numbers in an Excel cell (ex. 01-00), but the formatting wants it to default to a date (ex. Jan-1). How do I delete this formating so I can enter simple numbers?
2
votes
5answers
4k views

How do I align a column of numbers by decimal point in microsoft excel when some of those numbers are negative?

Let's say I have a list of the following numbers: 0.02 -0.25 -0.04 -4.13 -1.12 5.24 -2.12 -11.36 40.61 -141.20 -1.82 -6.48 How would I align them in a column such that they are ...
1
vote
1answer
67 views

Excel_macro_pivot table_analyzing data

I have two problems with my data in Excel. I have this table, so for every day in the year I have got 24 values, that´s 365 columns. I need to write a macro, that transform the data vertically, ...
2
votes
2answers
402 views

How do I stop Excel from checking the validity of hyperlinks before it opens them?

If you open an Excel spreadsheet containing external hyperlinks, when you click the link, Excel will check that the link is valid (i.e. doesn't return a 404 error) before actually opening it in the ...
0
votes
1answer
150 views

How do you use conditional formatting in Excel to format based on previous cell information?

I have a document that is created to monitor complaince. I would like to have the following rules: Highlight the cell if it meets a goal - I've figured this out and the formatting works. Highlight ...
0
votes
3answers
172 views

Multiple “If” answers in one cell

I am trying to make a fishing tournament spreadsheet.... I would like to perform in once cell that if their position was first, they get 100 points. if their position is second, they get 90 points, ...
1
vote
1answer
1k views

Macro to Move Columns Based on Header Criteria MS Excel

I'm starting a new position in 8 days and I'm quite new to visual basic. I was able to job shadow a current employee and in 1 of the reports, the individual was sifting through 100 or so columns ...
0
votes
1answer
92 views

Can I get the properties of the color of a Microsoft Excel cell in numbers/text?

I want to count the yellow, red and white (no color) cells in a column (range) within a Microsoft Excell sheet. The colors are equal (i.e. only one RGB value of yellow is used, not light/dark yellow ...
0
votes
2answers
111 views

Entering text value representing a sum in Microsoft Excel

Please see this image: Under "Monday" where I have typed rent, I would like that cell to display the text "Rent" still, but to represent the value of rent on row 4. For the formula in "balance" ...
1
vote
4answers
5k views

Excel: Change all cells with one character to something else

Is there a formula I can use that will change all cells with one character to something else? For example, I have cells with single letters and no matter what the letter is I want that cell to ...
0
votes
0answers
91 views

work with huge 15000 lines excel files containing formulas

We work on a huge excel file. it contains a sheet setting 22000 lines We use Excel 2011 on Mac and Windows on Intel i7 with 8Gb Ram. We have disabled the automatic computation of the file the file ...
3
votes
1answer
429 views

Automatic LaTex document generation from Excel spreadsheet

I have some data in an Excel file from which I have to generate a report. I repeat this task fairly regularly and am looking to automate it. I have a LaTeX project into which I usually just copy data ...