**1**

vote

**0**answers

16 views

### Conditional formatting with several conditions depending on different cells

I currently have a table in excel that looks like
.
The table shows four projects, each with three stages with each having an expected and actual start date for that stage.
I want to create a ...

**0**

votes

**0**answers

9 views

### Advice making a multi line chart with daily count data

This is what my raw data looks like.....
raw data image
I would like to use this data to create a chart that display's Install date in the X axis, a daily sum of records for each installed by name in ...

**0**

votes

**1**answer

5 views

### Excel 2007: View/focus on last rows when opening the workbook

I have about 4700 rows on my sheet. When I open the workbook, it always focuses on the first rows. I want it to focus/view on the last rows of the sheet instead. It doesn't have to select. In fact I ...

**0**

votes

**0**answers

8 views

### How do I assign a dollar value to a word in a specific cell?

I am trying to assign a dollar value to a cell titled "internal bridge." Cell B4 (Internal Bridge) should equal $500. In cells B5 - B18, I intend to use number values (1-50) to represent the number ...

**0**

votes

**0**answers

14 views

### Defining a range in excel for index/match

I'm trying to return a "best" value, but there are two criteria for a threading calc. One column has stress, which just has to be higher than a given value, and the other would be where you want the ...

**0**

votes

**0**answers

44 views

### without iteration condition, =A1+C1 in C1 cell,

I've tried iteration condition, but it is not taking only the 'A1' value, if I put some value in some other cell, C1 is calculating like =A1+C1 in C1 cell,means
A1 value is 5, in C1 i put this farmula ...

**0**

votes

**1**answer

17 views

### How do I return the last word of a string of text?

If any of you have been following the progression of my questions, then this may come as no surprise. Be that as it may, I have to ask it. I really did attempt to find an answer to this online and ...

**0**

votes

**0**answers

19 views

### How to stop Excel “trying to connect to <my file server>” and make it just save the file?

Client: Excel 2007 on Windows 7.
Server: Samba 4.1.17+dfsg-2+deb8u2 on Debian Jessie/AMD64
When opening files from a network location:
Excel takes a very long time to start opening the file (...

**0**

votes

**1**answer

19 views

### How can I remove a cell from a range for a property lookup array

Lets say I have a value, A123456, in a column A, row 1, and i want to check if I have the same value in other rows of the same column, regardless of the length of the values as long as it has the same ...

**0**

votes

**1**answer

16 views

### How do you return the last letter in a string of text in an adjacent column?

Rather than do 600+ entries manually before seeing if some superuser might be able to answer my question, I'm going straight to "the Oracle" first this time. By the way, @Scott Craner answered my ...

**-3**

votes

**0**answers

19 views

### please help me to put a formula in this cell?

the calculation in the cell E is based on the net change in F and G. For example "when i enter an amount in the cell F3, then it should add up with the amount entered in the cell D3. and likewise when ...

**-1**

votes

**0**answers

14 views

### How do I transfer data values from a chart to a table on Excel?

I have data that is listed in a chart, for example
Hello1
World2
Biscuit3
I would like to transfer this to a data table, but the numbers follow a specific pattern. For example, the table would be:
...

**-3**

votes

**0**answers

23 views

### Need a VBA Code for multiple text cell to row in excel

Hi Kindly help me out to resolve this in excel through macro:

**0**

votes

**1**answer

16 views

### How do I set up a formula that will return a certain value dependent upon a portion of text in a cell?

I've got a column of text. If the text of the cell contains
el
I want it to return "M" in the adjacent column. If the cell contains
la
instead, I want it to return "F" in the adjacent column.
...

**1**

vote

**1**answer

24 views

### Is there any way to separate every four row in a different column in excel?

I want to separate every four row into column.
Excel Screenshot
Like in screenshot, first 5 row that I bold of A becomes column of C D E F & G
I want every 5 row of A becomes column of C D E F &...

**0**

votes

**1**answer

8 views

### Running Macro disables formula entry

Run a Macro on an Excel 2007 workbook, now formulas no longer work in the modified workbook? I can type a simple (like "=5") in a blank cell and hit enter and what I typed is shown, not the result of ...

**2**

votes

**2**answers

36 views

### Searching an array from bottom to top

I have a table array $E$14:$G$851. Column E just contains unique identifiers, lets say a/b/c/d etc, column F contains hundreds of numbers all less than or equal to 20 and column G contains the values ...

**0**

votes

**0**answers

25 views

### How do I add multiple date values?

I already used the function
=IF(AG2<(TODAY()+2),"DELIVERY DATE",IF(AG2<(TODAY()-1),"DONE","ON GOING"))
but the value of "DONE" is not working. Please help me out.
This is the criteria:
if ...

**0**

votes

**1**answer

21 views

### Excel formula to read 2 of 3 cells repeating or not

I am having trouble getting a formula that will work the way I want:
IF 2 or 3 of the last 3 cells (A2:A4) were b, AND cell A5 is b, then C5=+, otherwise -.
IF 2 or 3 of the last 3 cells (A2:A4) ...

**2**

votes

**1**answer

18 views

### Is there something about filling Excel spreadsheet cells with CTRL+SHIFT+ENTER that prevents a successful sort?

I have a long list of entries that I want to sort randomly. I highlighted a column, typed in =RAND(), and then pressed CTRL+SHIFT+ENTER, and voilà, my column was filled with random numbers. I then ...

**0**

votes

**0**answers

10 views

### Why is an embedded object in a hidden cell copied over when I copy/paste only visible cells?

I have embedded pictures in cells in my Excel 2007 workbook. I have already formatted all of them so they "Move and size with cells." The pictures are hidden when I filter in Excel. However, when I ...

**0**

votes

**0**answers

17 views

### Excel SUMIFS Formula Sequential Date Criteria?

=SUMIFS($I$2:$I$2221,$M$2:$M$2221,"VISA",$B$2:$B$2221,"June 1")
This is the formula I am using for a sales analysis worksheet, that takes the clutter from the POS report and breaks it down in a ...

**2**

votes

**1**answer

55 views

### Macro to autofill columns in Excel

I've recorded a macro in Excel that fills the columns with formulas.
However, it's limited to the range I was using in my test data, i.e., it doesn't fill down to the last row of data when I use a ...

**0**

votes

**1**answer

23 views

### How can I select the whole string except for the first character from a cell in Excel 2007

I have multiple tables where 1 column contains a string which is a combination of a letter and a number. For example these values can range from B1 to B1000000. My present solution to automatically ...

**0**

votes

**0**answers

14 views

### Refresh Excel Connection without source being open

Morning all,
I have a query regarding refreshing Excel connections.
I have a company workbook that has many sheets and is in constant use all day, however I have a connection created to this which ...

**0**

votes

**1**answer

49 views

### How to change a negative value to a positive number not exceeding 49

Hi I have the following question that I am struggling with solving
I have si numbers from a lotto draw to which firstly I would like to subtract each number by 25 and record into cells , therafter if ...

**0**

votes

**4**answers

68 views

### How can i get one certain row , one line below?

What i mean is that i have an excel doc with 4 rows
A B C D
1 Data1 Data2 Data3 Data4
2 Data5 Data6 Data7 Data8
I want every D row data to get on the below line and ...

**-1**

votes

**0**answers

33 views

### Import images into excel

Import images into excel using empcode to match file name images located in D:\images

**0**

votes

**1**answer

20 views

### Updating link paths with Word VBA

I have the following links to Excel in a word document:
The issue is that when changes are made the document version on both the excel sheet referenced and the word document change.
As such I will ...

**0**

votes

**1**answer

28 views

### How to convert 3 colum in an excel matrix?

I have many data set on 3 column as the tab above
and I would like to convert to a
like the one in the picture.
Is there a function that do this in MS-excel 2007?
I think I need to create a ...

**0**

votes

**0**answers

13 views

### List Sort with New Rows - Excel Macros

I am trying to record a macro that sorts my list, but am currently at a wall - I need this sort to adjust to my list depending on adding/removing rows.
My current code scans the list for which cell ...

**4**

votes

**2**answers

54 views

### How to Use (--) this in Excel Formula

I found (--) this to add criteria in a sum Function, can you please tell me its exact use.
And is this function(--) (whatever it is called by) can be used in any other formula?

**0**

votes

**1**answer

10 views

### Linking Excel Workbooks

I work for a large agency and created a spreadsheet for employees to track time spent throughout the day working on a series of duty assignments. I designed a separate workbook for each employee where ...

**0**

votes

**1**answer

21 views

### Excel 2007 Custom Data Validation, Excluding characters in large range

Trying to create data validation (absolutely no macros, it is simply not an option), where a user can type in only Basic characters
(A-Z,a-z,0-9,-,~,',\,/)
So what I tried to do is create a ...

**2**

votes

**1**answer

25 views

### Counting Divide-by-Zeros

I can easily count number of #N/A's in a column with the array formula:
=SUM(--ISNA(A:A))
How would I count the number of #DIV/0!'s in a column ??

**0**

votes

**0**answers

35 views

### Stumped with how to write Excel formula: How to check if multiple values in a single row are the same in two different sheets?

I'm sorry, I know that title must sound confusing but I'll try to explain it better here.
Essentially, I have to check if a row in a Sheet2 has two of the exact same values in another row in Sheet1. ...

**0**

votes

**1**answer

14 views

### Excel auto Text formatting based on values within a range of cells

Need help finding a way to auto format a text response based on values in another set of cells. There are 3 values in Column B,C, and D and depending on the highest value of the three, the adjacent ...

**1**

vote

**1**answer

37 views

### Excel replace multiple text options within one cell with other text

How can I replace one set of text options with another? I was thinking that an Index/Match combination might work, but I cant figure it out. Perhaps a VLookup function?
For example:
My report output ...

**0**

votes

**1**answer

41 views

### Editing CSV file in Excel always converts number column to scientific notation [duplicate]

I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific ...

**1**

vote

**0**answers

28 views

### How to add data vertically while xtracting tables from web page to excel

My code
Public Sub Raju()
Dim alertTime As Date
alertTime = Now + TimeValue("0:05:00")
'
' mymacro Macro
'
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")
...

**0**

votes

**0**answers

9 views

### Copying Conditional Formatting rule to range of cells and automatically updating the cell references

I wanted to apply Conditional Formatting to range of cells A2:A30 using a formula =Countif(A2:A$30,A2)>1. It works and gave the desired result. However when I go to any cell other than A2 and click ...

**0**

votes

**1**answer

12 views

### Excel scatter plot with two x series and one y series

My data consists of a y value and the two x values that can be used as inputs to a quadratic equation to give the y value. I'd like to plot them, ideally with separate colours for the positive and ...

**-1**

votes

**1**answer

19 views

### How do you consolidate “date. Time1 and Time2”? [closed]

How do you consolidate "date. Time1 and Time2"
For example:
A B C
1 Date Time1 Time2
2 09/04/2016 05:03:15 AM

**0**

votes

**1**answer

37 views

### Mirroring formulas to multiple sheets in Excel

I have an Excel Workbook with multiple Sheets each using the identical layout, but with different sets of data. From time to time, I need to vary the way the values are calculated, but I don't want ...

**1**

vote

**1**answer

43 views

### How Can I make an excel column of Hyperlinks open in NON default browser

I have a ms excel 2007 worksheet with a column (A) of hyperlinks using the excel function in this way =HYPERLINK(A2,"url".
How Can I make (if this is possible) open all cels on that column in the NON ...

**0**

votes

**0**answers

21 views

### I am looking to reverse lookup missing numbers from a VLOOKUP in Excel

Hi please let me know if this is a duplicate but I did a brief search and did not find anything that wasn't a ton of code that I couldn't relate back to my spreadsheet.
I have excel 2003-2007.
I ...

**0**

votes

**1**answer

44 views

### MS Excel - I wish to count unique values based on a parent column

I am very new to Excel. I need some help in counting unique values in each of three columns (considering them only one at a time) with respect to a parent column (the first one (A) in the image). Can ...

**3**

votes

**1**answer

51 views

### does Excel copy only visible cells when a filter is enabled

According to MS doc
excel 2007 https://support.office.com/en-us/article/Copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e
excel 2013 https://support.office.com/en-ie/article/Copy-and-...

**0**

votes

**2**answers

39 views

### Apply Custom Number Formatting to Error values

I'm trying to apply a custom number format to cells in Excel 2007 that return an error value.
I understand that I can apply custom number formatting to number/text values in the form POSITIVE;...

**1**

vote

**1**answer

335 views

### Is there an English Office Language Interface Pack?

Located in France, I have only access to a French version of Excel and would like to change it to English for programming purposes. I want to use this model, based partly on Excel VBA code. Currently ...