turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- 150K Members
- 1,052 Online
- 36.8K Conversations

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

1443 Conversations

- Mark all as New
- Mark all as Read
- Pin this item to the top
- Subscribe
- Bookmark
- Subscribe to RSS Feed
- Invite a Friend
- Sort by Conversation Start Date

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Custom List Message Item | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|

Hi, I was hoping someone could help me with a formula. I am trying to pull the data from the assumptions tab into the leads tab by reading the property type (C column), zipcode (M column) and beds total (P collumn). The array that it needs to be pulled fro ... Read MoreBrady,
provided that zip codes and number of beds are the same and in the same order for both tables. _table=MATCH(C2,{"Residential";"Condominium"},0)... Read More | ||||||||||

Hello, I am not sure how to attach the file. I think its there, but not sure. Formula found in column C: =SI(NB.SI(D10:II10,"x"),MIN(SI((D10:II10="x")*(D$8:II$8>=AUJOURDHUI()),D$8:II$8))-AUJOURDHUI(),0) The formula calculates the number of days that are t ... Read MorePascale,
Tabelle2!A:A6 contain the search criteria: x, V, M, F, Fc, Fr.
=INDEX($8:$8,AGGREGATE(15,6,COLUMN(D10:II10)/COUNTIFS(Tabelle2!$A$1:$A$6,D10:II10),1))-TODAY() Read More | ||||||||||

I want to take the information in column A in the Program of Study where column D IS BLANK and put the results and place the results in column N in the New Data part of the sheet. Is there a formula or function that will help me accomplish this. The Progr ... Read MoreHi @Robert Cobb
In your case, i will 1. Apply filter "Blank Cells" in "Column D" in "Program of Study". 2. Then select data top to bottom in "Column A". 3. Will Select visib ... Read More | ||||||||||

Hi,
I am trying to write a formula based on 3 different types of variables. I started by using an extremely long If(and statement and eventually excel wouldn't let me keep going. You can see what I was typing in the sheet I attached.
I believe that I need ... Read MoreBrady,
=SUMPRODUCT(CHOOSE(BE2,assumptions!$C$4:$I$7,assumptions!$C$10:$I$13)*(assumptions!$B$4:$B$7=R2)*(assumptions!$C$3:$I$3=I2))*BA2 Hi Brady,
Please test this formula: =INDEX((assumptions!$C$4:$I$7,assumptions!$C$10:$I$13),MATCH(R2,assumptions!$B$4:$B$7,0),MATCH(I2,assumptions!$C$3:$I$3,0),BE2)*BA2 And ... Read More | ||||||||||

=IF(D2>89,"A",IF(D2>79,"B",IF(D2>69,"C",IF(D2>59,"D","F")))
I’m trying to do this formula but instead of using =IF(D2>89,"A" I’m using =IF(D2>D22,"A" And when I change the number in the cell With the cell my formula come back with #name? I close all the pare... Read More Usually the #Name error indicates there is something wrong with your syntax. Do you have a non-sensitive copy of your workbook that you could provide or perhaps a few sc ... Read More | ||||||||||

I am creating a code that would make all odd rows yellow and all even rows white It's not working properly right now so I would appreciate any help editing it! The error is that the subscript is out of range
Sub loops_exercise() Dim R As Integer This is a little bit simpler then what you have. Instead of looping through the cells individually one at a time you can just color the whole row at once.
Note: Column ... Read More | ||||||||||

Always when i sum two large no. using the formula [=SUM(:)] it gives '0' as output. Please help me out !
Hi,
Let me now length of values.
Use anyone of folloiwng, if you sum only two large numbers. =6778978987+676768767... Read More | ||||||||||

Help me edit this code to achieve this end result. As much as possible, please keep the format the same for "select case" and "Loop" Sub QuestionFive()... Read More Hi ONG,
Back to you again :)
You can depend on the same code I suggested in the previous conversation, but with some changes, as follows: Sub ODD_EVEN_IN_Yellow()... Read More | ||||||||||

Hello,
I would like to introduce a formula that will fill in red the cell with a time range between today and the next 15 days, yellow between the following 15 days, and green a cell with a date later that 30 days from now.
How can I do it?
Thank you very ... Read MoreHi @Francesc B.
Please see the attached file. I just applied it for Range (A2:A24).
Type and test it. Read MoreBest Response confirmed by Francesc B. (New Contributor)
| ||||||||||

Hi - I'm trying to write a formula to add the number of hours across a month that somebody might work in a roster. In that month they might work in 3 different areas, so I need to have the formula along the lines of COUNTIF the conditional formatting = " ... Read More
Using the attachment provided by Matt Mickle, you can use the following formula in F8:
=SUMIF(D8:D15,"TRN",D9:D16) Blessings! Claire-
Maybe try something like these conditional IF() formulas (See attached excel file for example):
Read More | ||||||||||

I am seeking a way to create a rule to assist me with schedule readability. I want to enter a "B" into any cell and have the cell to automatically populate with the corresponding information contained in another column and the same row. For example: If I ... Read MoreHello,
Excel cells can contain either a formula or a value. If you enter a value into a cell, it cannot automatically change to a formula that pulls data from somewhere ... Read More | ||||||||||

I'm working on a macro that will basically take information from a data dump worksheet and copy/paste certain columns into 6 additional sheets. | ||||||||||

Hi there,
I have a large data set and would like to sum a column if a certain date falls between two others, here is a sample of the data set; A B C D
Chris,
your dates in the first table are from 2011 and the dates from the second table are from 2010. They will never match. Thus the result is 0. Read More I have tried SUMIF. And it turns out Zero. I didn't know why, either. Sorry. | ||||||||||

Hello
I am linking multiple sheets on excel. If I pull data through to sheet 2 from sheet one. Then add other columns in sheet 2. But then add data in sheet 1 and sort the column. I would like the additional data in sheet 2 to move along with the formulated... Read More Andrew,
this is not possible without a helper table.
However Matt Allington posted a workaround. But it is not easy to set up. Self Referencing Tables in Power Query Read More | ||||||||||

Hi,
I have created a row of cells that gives a random number between two values. Beneath that row, i would like to create arow which directs the values of the collumn A in the rownumber which is randomly chosen in the row above it. For instance:
Did you have the value of 25, 14, 42. etc in one cell or separated cells.
Or else show me an example. Read More | ||||||||||

Question will be explain as if you are looking at the attached work book.
The date column has Conditional Formats that change colors within 305 - 365 days of the date that is the cell.
I'm trying the get the remarks column to do the same thing but change ... Read More
You can do it with conditional formatting. If you clarify the above
Hi,
Will you put date in remarks column? or any other comments.
Coz, Can't understand. | ||||||||||

Hello!
I have fo ... Read MoreYou can use the range drop down in the top left corner by the function box. This functionality is already built into the software. There is no need to make buttons unle ... Read More | ||||||||||

Hello! I'm just getting my feet wet with formulas in Excel and I think I need a nested IF/OR formula.
Basically I want to compare two sets of cells. If there are any matches between the cells, I want the formula to return true. If no equivalence, then fal ... Read MoreHi, to all!
Another options could be:
Hi Troy,
You can expand the OR function with two more logical tests as follow: =IF(OR(A1=A3, A1=A4, A2=A3, A2=A4),TRUE,FALSE)
Update: You don't have to nest another IF as y ... Read MoreI figured it out:
=IF(OR(CELL1=CELL3,CELL1=CELL4),TRUE,IF(OR(CELL2=CELL3,CELL2=CELL4),TRUE)) | ||||||||||

I don't want the person I'm sending my spreadsheet to, to be able and view columns that I have hidden. How do I do this? Thanks! | ||||||||||

I have 2 worksheets with similar data: 1 has check #'s that are uncashed and the other has all checks disbursed and the recipient's address. What is the best way to extract the address data based on if the check is in the uncashed column? Any ideas/help wo ... Read MoreHi Anita,
Could you please provide us with a sample of the data to figure out the most appropriate solution?
Regards | ||||||||||

Hi, I'm just looking for some help with my maths c assignment that requires basic knowledge of excel and I have no idea what I'm doing. I need to be able to enter the breaking strain of a cable and it tell me what cable I need and how much it will cost me ... Read MoreHi Grace,
I suggest you follow this series of videos which is about Excel & Business Math Class.
Regards Read More | ||||||||||

Hello All,
(Column E holding different values , with list of 5 numbers each time - I get it as raw nu ... Read More | ||||||||||

I have a table with 6 columns and I need a formula that count the numbers of times that "End A" and "End B" shows for example row 3 and 4 match columns A (A3 = B205 and A4 = B205) and E (E3 = B260 and E4 = B260) so the formula in row 3 it will show as bl ... Read MoreHi Fernando,
Please try this formula in cell F2 =IF(COUNTIFS($A$2:A2,A2,$E$2:E2,E2)=1,"",COUNTIFS($A$2:A2,A2,$E$2:E2,E2)) And find it in the attached file.
Regards Read MoreBest Response confirmed by Fernando Salgueiro (Occasional Contributor)
If I am correct, the vlookup function only allows you to check for one condition. You may want to look into using the sumifs function as you can use multiple conditions t ... Read More | ||||||||||

Good Morning,
I need some help on the following formula for an Invoice List in which I have in one cell the following formula =IF(AND(B26="Carbon"),"59.00",IF(AND(B26="Alloy"),"89.00")) but then in another cell where I have =SUM(F32:F36) in which it woul ... Read MoreAdam-
Try using the numbers without the quotes. The quotes are converting the numbers to text. Here is an example image as well as an example file for your reference. ... Read More
Hi Adam
It may help to see your spreadsheet or a sample of it. Are you able to upload it for review? Cheers Damien | ||||||||||

This article describes the Geography data type for Excel 2016. I've upgraded but it's not available. What do I need to do different?
Read More |

Top Liked Comments

Share

Popular

Learning Resources

Programs

Values

- Contact us
- Privacy & cookies
- Terms of use
- Trademarks
- About our ads
- © 2017 Microsoft