**0**

votes

**1**answer

24 views

### Excel: How to check values in mutiple rows which mark values per day and highlight row with the earliest entry

I have a database wich shows value assigned to each customer in each week of the year. What I want is to have highlighted (i.e. marked with X, at the very end of my report) the earliest week on which ...

**1**

vote

**1**answer

28 views

### Why can Excel 2007 not calculate sub formulas right? [closed]

I have the simplest possible scenario:
open a new Excel 2007 document
In the first row put 6.99
In the second row put 4.99
In the third row put =A1*0.4
And in the fourth row =SUM((A2-A3)/A2)
This ...

**1**

vote

**1**answer

80 views

### What is the Excel Formula to calculate based on consumption and rate

I need help to come out with a solution for this:
Actually I want to calculate my electricity consumption. as the attached pic. the first consumption 0-200kwh, rate $0.218, for 201-300 consumption ...

**0**

votes

**1**answer

47 views

### Change name box of a image inserted into excel worksheet

When you insert a picture into a excel worksheet, you get automatically Picture 1, Picture 2, and so forth...... I have a function when a picture is selected to put black border around it. Problem is, ...

**0**

votes

**0**answers

36 views

### Excel 2007 Unprotect Sheet prompt in password protected sheets on Windows 7 machines

Windows 7 users of software I created in Excel get an "Unprotect Sheet" prompt when clicking on any sheet or cell in a sheet that is password protected. They hit cancel, sometimes several times and ...

**1**

vote

**1**answer

31 views

### How to plot a complex table relation on excel?

How can I generate a table as displayed in the image attached using Microsoft excel. The x and y axis in yellow are simply perfect squares while The table content is composed of axis sums. I cannot ...

**-1**

votes

**1**answer

21 views

### Excel - Check if there is a match to a cell in the rest of the workbook

I've got a workbook that has spread a list across 10 different worksheets, but the list has become out of date. I'm trying to find out which of those in the new list aren't already included in one of ...

**0**

votes

**3**answers

50 views

### Vlookup to check all values before returning value?

i have this Project, I have to check values from a different sheet and copy the value of the Cell beside it.
Sheet 1
Billy
Paul
Mike
Jesse
Sheet 2
Billy |
Paul | X
Jesse |
Billy | X
Mike | X
I ...

**0**

votes

**2**answers

53 views

### Removing Space in a number

I have gone through many solutions for removing of space in a number but my data is as below:-
( 76,120.04 )
Here space in staring of number, after comma, & ending of number also. So in this ...

**0**

votes

**2**answers

40 views

### Excel VBA Run-time error 9 subscrit out of range

While closing the workbook I am getting:
Run-time error 9 subscript out of range
This is the VBA code:
Set wbk = Workbooks.Open(path & filename)
wbk.Sheets(sheetname).Range("b6").Resize(...

**0**

votes

**1**answer

55 views

### Excel highlight row if 2 cell values match

if I have cell D2 (input value 100) and M2 equals the value from another sheet and that value matches the value of D2 how do I highlight the whole row not just the cells?

**0**

votes

**1**answer

28 views

### How do I copy elements from one sheet to another?

This is a slightly complicated question because it has two dimensions.
I have a row of formulas in one sheet in a workbook in Excel. I want to copy the numbers in that row as a column to another ...

**0**

votes

**1**answer

34 views

### Conditional Formatting help in excel (highlight certain row if a cell in a column displays #N/A)

I am trying to use conditional formatting to highlight a specific row of cells if a certain cell displays #N/A. I tried to use the function = isna() but it did not work as it only highlighted the ...

**0**

votes

**2**answers

2k views

### Looking to return certain value based on how many times a value matches across two columns

I've got ID numbers associated with up to two values (SYS-A AND SYS-B) in another column, but each ID could appear could appear multiple times under SYS-A and/or SYS-B. I need Excel to look at each ID ...

**0**

votes

**1**answer

25 views

### MS Excel is automatically protecting worksheet

I have a MS Excel sheet that is, periodically, being automatically protected. How do I stop this from happening?
I can manually unprotect it, but since I am frequently modifying and saving this ...

**1**

vote

**1**answer

61 views

### why am I getting compile error when trying to copy data from master sheet to multiple worksheets

I am very new to VBA and macros so I apologise if this is simple. I have found similar posts but nothing that I am able to adjust to my problem. I found code to create a new worksheet for every new ...

**0**

votes

**1**answer

26 views

### Transfer only certain columns in excel 2007 to another sheet

I have an excel 2007 sheet I am using as my product database. It has various columns and rows with data as below:
Code Company Image Code Picture Page
UV001 UV Gear uv001.jpg http://www....

**1**

vote

**1**answer

47 views

### VLOOKUP for latest non-empty cell

Basically, I've got the following spreadsheet.
There are dates along the top. I do a certain amount of past papers each week, and record the highest score I get in a week in cell (paper, week). The ...

**0**

votes

**1**answer

38 views

### Name in output column should be present only active member is “A” Else should check next row also now cell should be empty or Zero

I Have two workbook one have data as shown in image Sheet 1
and second workbook is output sheet2
The problem is I want data in output sheet from sheet 1 only if active column in sheet 1 Have " A" ...

**0**

votes

**0**answers

30 views

### How to transfer word paragraph to excel row

I have a word document with question and answers. I need to convert this data to an Excel spreadsheet. I need question number, questions, answers, explanation in separate rows.
Example
In my word
1....

**0**

votes

**0**answers

25 views

### Excel not showing special character in my system

I had issues with special character encoding in csv generated from my website. Now encoding changed from UTF-8 to UTF-8 with BOM. But MS Excel 2007 in my PC is still not showing that properly. But in ...

**0**

votes

**1**answer

36 views

### Lookup formula isn't always accurate

Column A & B are examples from a worksheet that is automatically updated from a a historian data base (the data upload changes every time it is refreshed). Column F & G are examples from a ...

**0**

votes

**0**answers

11 views

### Possible to Rank by greatest difference in a pivot table?

I have a pivot table that gives me the difference between two time periods. I would like to rank the difference column by greatest delta. Any idea on how to go about this?

**0**

votes

**1**answer

49 views

### Values not available when using INDEX/MATCH functions

Following on from my previous question: How to calculate an average value based on duplicate groups?
I am trying to create a column "Data for Standard Time" which will contain values matching a ...

**0**

votes

**1**answer

22 views

### Microsoft Excel 2010 Workbook Comparison Code

So I have these two workbooks, the data will not be in the same format, but will have a unique identifying number (like a ID Key in Access).
The goal of my code would be to identify rows with the ...

**1**

vote

**1**answer

64 views

### Force row numbers to remain the same in formula

How do you force the focus of an Excel Cell to remain the same?
I have a question in the same reference above link. I am trying to match the data I have in Column A and Column B. If data matches it ...

**1**

vote

**1**answer

8 views

### Unable to fix right to left sheet direction in excel 2007

Whenever i am opening a new sheet in excel 2007 it is opening from right side like F | E | D | C | B | A how can i fix it like before, A | B | C | D | E | F. Is there anyone suggest me i have done ...

**2**

votes

**2**answers

36 views

### Labeling a shape in Excel 2007 VBA

I've created a macro to make shapes using AddShape.
I name it with .name but I can't put a label on the shape icon with the macro.
If you manually click on a shape you can enter a formula to place a ...

**0**

votes

**1**answer

31 views

### Excel, one cell takes a value from another but want to subtract from another cell

Currently F18 is =L27
I want it to equal that cells total (that cell adds tons of stuff up I'm working from something that have at work but it's old and thou I could just manually edit it with actual ...

**3**

votes

**1**answer

48 views

### How to calculate an average value based on duplicate groups?

I have a table which contains data recorded at various times. The data should have been recorded at 5-minute intervals but this wasn't always the case.
Therefore, to try and clean this up:
I set ...

**0**

votes

**1**answer

43 views

### matching columns with nearly similar values in Excel

I have 2 columns A and B with persons names (more than 100 values per column):
Column A Column B Column C
1 John Brett Rise Matthew ...

**-1**

votes

**1**answer

30 views

### Add timestamp excel with formula

In an Excel spreadsheet, I want to add a formula that when I type a text in a cell , it adds the current time after the text I type ( in the same cell ).

**0**

votes

**0**answers

13 views

### hiding rows in a closed workbook

I have a couple of thousand of files in which I need to hide specific rows without opening them. (I have got 2400 files).
Is that possible?
I've been looking for a solution on internet for a couple ...

**0**

votes

**1**answer

53 views

### How to format entire row when any cell of the row contains any value?

I want when there is any value (whether any alphabetic or numeric value) in any of the cell into the row from a1 to p1 then the entire row (from a1 to p1) should be formatted.
For example there is ...

**0**

votes

**1**answer

41 views

### Change a cell number in formula from another cell [duplicate]

Basically I have this formula:
=(MIKE!$B8)
and I have a bunch of cells withs Numbers like so:
Cell | Cell Number Change
C1 | 10
C2 | 16
C3 | 29
C4 | 40
C5 | 61
What I want to do is to be able ...

**1**

vote

**1**answer

25 views

### Excel: Find rows that are duplicates except for two columns

I am using a dataset that has 6 columns. I would like to find any rows that have an exact match in any other row, aside from two columns. So If my data were like the following:
WT 40 SH ...

**0**

votes

**2**answers

35 views

### How to add alphanumerics in excel

I am maintaining stock of flavors in a row:
Cell B1 : 5vanilla,5cola,5mango
Similarly
Cell C1 : 3vanilla,3cola,3mango
Is there a sum formula with which I can get
auto sum in Cell F1 as 8vanilla,...

**2**

votes

**2**answers

121 views

### Linking a chart series' name to a range through VBA

I would like to link the chart series' name to a range on my worksheet, but not the whole string in that range. For example, instead of linking the name to a cell that contains "201601", I want the ...

**1**

vote

**1**answer

125 views

### Create Bat File With Excel Data with VBA

I took some research from google
Sub ExportRangetoFile()
Dim wb As Workbook
Dim saveFile As String
Dim WorkRng As Range
Set WorkRng = Sheets("Match").Range("K:K")
Application....

**0**

votes

**0**answers

38 views

### Excel: value between two times [duplicate]

I have an Excel sheet which gives me the number of workers working on a given hour. However I cannot seem to get it to work for overnight shifts.
I know it will work if I add a date to the time but ...

**0**

votes

**1**answer

84 views

### How to drag multiple instances of a range at the same time in excel

Edit: This question is completely revised to incorporate screenshots as suggested by the commenters.
I track student grades in Excel using a spreadsheet something like this
I often find myself ...

**1**

vote

**0**answers

8 views

### Excel work tabs sharing data

I'm working with Excel; in tab 1 (Data Sheet) I have lines of data, each line represents a part with all its history and associated cost. the 2nd tab pulls data from tab 1 based on particular columns ...

**0**

votes

**0**answers

51 views

### EXCEL table linked to WORD overwrites WORD table properties

I have 30 EXCEL tables - Linked with Formatting - into 8 WORD documents.
I would like the Table Properties ROW in the WORD document to Repeat Header and Not allow row to break across pages.
This is ...

**0**

votes

**2**answers

148 views

### What is largest value (number) that I can store in an Excel VBA variable?

I am using Microsoft Office Excel 2007.
Suppose I have the number 12500000000000.
Dim value1 as long
value1 = CLng(copyrng2.value)
'where copyrng2 is a range (cell) variable containing ...

**0**

votes

**1**answer

56 views

### Excel, How to get last value in second column for a name selected in first column?

I have an excel sheet in below state:
Column1 Column2
A 10
X 20
C 30
D -45
A 50
B 61
C -08
D -...

**-1**

votes

**1**answer

44 views

### In Microsoft Excel, need to pull information from on sheet to populate cells in other sheets, based of a id number search

I have one sheet in excel that I would like to enter an ID number "707442" and have excel go to another sheet and search the column that has the ID numbers. When it finds the ID number I would like ...

**0**

votes

**1**answer

113 views

### Loop down column until blank cell

The following formula works well if I define each cell (over and over), but I need a loop that will run down column A & B for hundreds of rows.
I have tried and just cannot seem to be able to ...

**3**

votes

**1**answer

35 views

### Excel formulas - how to make a cell blank down the page

I am having trouble figuring out the formula for my budget.
Cells look like this
A B C D
DATE WEEKLY BILLS TOTAL
2015 $50 $1,956.73
Jan ...

**2**

votes

**1**answer

71 views

### VBA EXcel - I am getting an error (400) if using error trap getting no object/application defined error

My excel sheet has these data, 7 columns
sl.no | bed | 2| 4| 3|4|3|
some times column no 7 is empty, and then only I'm getting error
And my code
Sub sup_cal_area_sft()
Dim lru, plru As Long
Dim ...

**0**

votes

**1**answer

177 views

### Checkout/in Excel Workbooks from SharePoint with VBA

I have found several articles and past questions in SO that help with this, but I have added a twist. I found a way to map a network drive on my PC to the SharePoint folders. If I open a workbook that ...