**-4**

votes

**0**answers

20 views

### How do I filter dates? [on hold]

Can I see date only by month or maybe even weeks to see not the whole table, I know how to do that with filter is there any other way?
DEZINFECTION
DATE PLACE
11.11.2015 BETI
15.11.2015 ...

**0**

votes

**1**answer

16 views

### Count specific assets (one column) which belongs to unique users (depending on another column)

To get the total of In Stock. I used this formula and it works. but this formula works for specific text.
=SUMPRODUCT((A2:A6="In Stock")*(B2:B6="Laptop"))
I need simpler formula to count rest ...

**-1**

votes

**0**answers

22 views

### Java Installer crashing when accessing VBA code

I work usually with DDE Excel.
I have two computers, one with Windows XP and another with Windows 10 64 Bit. The problem happens with the latter computer.
I connect the computer with provider DDE ...

**0**

votes

**1**answer

33 views

### Spreadsheet formula for adding all values adjecent to multiple instances of text cells

Given a table with unique and duplicate text values in a column with number values adjacent in the following format:
A|12
B|23
C|98
A|66
D|86
E|3
B|25
A|65
.
.
.
The values are simplified for the ...

**0**

votes

**0**answers

16 views

### How to insert online pictures into excel with VBA

I want to add images from my web image repository so I have all the hyperlinks in row 3 (C3:L3) and in row 2 (C2:L2), I would like to automatically insert the image whenever I press the Display image ...

**-1**

votes

**0**answers

13 views

### excel formula - suming multiple columns of one row in an index

i want to sum 10 columns of data. I do not want to just sum based on the cell reference. I want to sell based on name ranges. However, I don't want to type all 10 named ranges into the sum box.
I ...

**0**

votes

**0**answers

15 views

### Conditional formatting of “difference lines” in a 2 series chart

I have 4 columns of data:
1st column is the name of the Route
2nd column is Time1 in decimal hours
3rd column is Time2 in decimal hours
4th column is TimeDifference in decimal hours (or decimal ...

**1**

vote

**1**answer

21 views

### Pie Chart in Excel, is it possible to have a slice for a remaining balance?

There is a budget for each employee to use on expenses. We keep track of expenses throughout the year as it gets used. At the end of the year, a lot of these budgeted dollars do not get spent and i'd ...

**0**

votes

**1**answer

35 views

### Excel: How to Group Dates Per Week in Line Graph

I have data that looks like this:
Actual End Date ----CP
2016-04-22------------4
2016-04-26------------3
2016-04-26------------9
2016-04-22------------7
...

**0**

votes

**3**answers

29 views

### Leaving a cell blank in excel, or display a different cell

I've tried to read the other posts and follow but I just can't wrap my head around this formula.
I would like F9 to:
be blank if no data is entered in D9
if data is entered in E9, then D9*E9
if ...

**0**

votes

**0**answers

31 views

### Excel converts comma delimited to tab delimited when saving [duplicate]

I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This ...

**-2**

votes

**0**answers

16 views

### About spreadsheets Microsoft excel 2007 [closed]

What if I want t calculate exams attempted when the other Rawls are blank and others have marks for the attended ones

**0**

votes

**1**answer

19 views

### Values need to copy from Col A to Col B in Excel without data loss

In my Excel, I have 2 columns For Ex: Col A & Col B.
In Col A I have 100 Records but in Col B having only 50 records that is scattered not in sequence.
I have to copy and paste the same ...

**0**

votes

**0**answers

6 views

### Sort data on repeat sequence

I want to order the data of my spread sheet on a repeat sequence
Actual
a a a b b b c c c
Desired
a b c a b c a b c
Any suggestions are much appreciated

**0**

votes

**0**answers

14 views

### Excel 2010, “Runtime Error '32809': Application-defined or object defined error”

I am having this error when I open up certain workbooks that contain macros. The files are stored on a network drive and this error only happens on a few computers which leads me to believe the ...

**1**

vote

**1**answer

40 views

### Excel IF formula using before or after date and amount

I need help writing a formula for the following. superuser sample
I hope you can see my image, and I explain myself well enough.
I want column L (my new column) to display column I(dollar amount) ...

**0**

votes

**2**answers

11 views

### Looping through two column to check for condition

I want to loop through column P and see if there is a cell that has the number "1" in it then at the same time loop through column N to see if there is also a number "1" at same row/column, if there ...

**0**

votes

**1**answer

44 views

### Check excel cell if font is a certain color?

I want to use vba to check if the text in a cell in excel is of a certain color, lets say red. Any ideas?

**-1**

votes

**0**answers

19 views

### How do I make this kind of line graph with MS excel or if not possible what is the next possible solution?

1I wanted to make this graph. The first figure is a single figure line graph with 4 vertically connected line graph . x axis is weeks and y axis is %. The other figure is an 8 line graphs connected ...

**0**

votes

**0**answers

25 views

### Excel 2007: Why #REF!+#REF!=number in evaluating formulas?

Total A.xlsx contains formulas adding cells (without the help of functions, just the "+" sign) from several files named 01 A.xlsx, 02 A.xlsx and so on.
All files (including the total) are in the same ...

**0**

votes

**1**answer

23 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

24 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

58 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

32 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

21 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

25 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

20 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

35 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 ...

**-3**

votes

**0**answers

63 views

### Vba formula that colors a certain data in a column when the corresponding data of the other column were found having more than 1 value

I have serial numbers of different products in column D. Each serial is duplicated several times through out the column. I want the serials that have more than one price corresponding to them in ...

**-1**

votes

**0**answers

10 views

### Excel 2007 - Sorting data

I have a spreadsheet set up with products down the left and months & values in columns next to each other across the top, this spread sheets is complete but I am unable to sort the data as I need ...

**0**

votes

**2**answers

50 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

29 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)
...

**0**

votes

**1**answer

39 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

23 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

20 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

1k 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

22 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

48 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

22 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 ...

**1**

vote

**1**answer

37 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

30 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

29 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
...

**0**

votes

**0**answers

19 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

33 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

8 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

50 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

31 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 ...