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,134 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 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|

I have a list of cities (column B) and the number of companies (column G) that based in these cities. The column B has duplicates for example: Column D (that represent a number of these companies) linked to the co ... Read MoreCould be =SUMIFS(G:G,C:C,INDEX(C:C,MATCH("Canterbury",B:B,0)),D:D,INDEX(D:D,MATCH("Canterbury",B:B,0))) | |||||||||||||

I'm sure if this is do-able in excel, but what I would like to be able to do is pull a number from a master sheet which relates to a name (column A contains the name, column B contains the number) and enter the number next to the name in a new sheet or wo ... Read MoreTry using a vlookup formula (see attached .xlsx file):
=IFERROR(VLOOKUP(B2,Table1333463[[#All],[Horse]:[Master]],2,FALSE),"No Data")
Hope this helps!
Read More | |||||||||||||

I am using =IF(ISNUMBER(SEARCH("RangeName",G2)),RangeName) to find words in a cell for list of words. Once that word is found I want that word to be the result if the words nor found than say FALSE. I used this formula in 7,000 cells only 1 cell came back ... Read MoreTry using a formula like the below. I have attached an example file for additional reference:
=IF(ISERROR(SEARCH($C$2,F2)),"FALSE",$C$2)
Read More | |||||||||||||

Hello, I have been using many different methods for attempting to convert text and date - but failing miserably!
Essentially, the way I can download data provides dates that appear like this:
Jun 13th 2017 10:44 Depends on regional setting and defined long date format, for US ones could work =DATEVALUE(SUBSTITUTE(A1,MID(A1,7,2),""))
Do your months normally show in English when you enter a correct date in Excel and format it to show the name of the month?
I suppose it is a string.
If so, you may consider LEFT and MID function to extract the information about year/month/day. Then, use the function DATE, you can have the da ... Read More | |||||||||||||

Hi,
I'm new into excel and doing some digging I cant find an appropriate solution. I am currently building a registry worksheet where I will log everyone that booked.
These are my three columns; 1) Early-Bird Discount Applies? 2) Price Level 3) Days booked
4 ... Read MoreI have an idea. But I think it is not good.
Since the first three columns have fixed choices. So I will first concatenate the value in the first three columns. For short ... Read More | |||||||||||||

Hi guys,
So basically what I am trying to do is let Excel determine if what tier we are going to use automatically so it's like this:
If the given weight (column B) is less than, equal to, or greater than the range in column I, then it should correctly se ... Read MoreMichelle-
I believe you can accomplish your task by using a Vlookup. Please reference the below post and the example file that is included in it . You will need to ma ... Read More | |||||||||||||

The IFS statement below works with the exception of the
=I ... Read MoreErin-
It's difficult to tell what you're trying to do with the formula alone. Is there anyway you could please provide a non-sensitive example file to give a little co ... Read MoreHi Erin,
For the logical test instead of SEARCH(...) use ISNUMBER(SEARCH(...)) | |||||||||||||

I have a data set (15,000 rows) in excel that looks like the sample below. Is there a way get to some thing that looks like this? Basically I want to count the entries by customer, get the last date, and output in one row. | |||||||||||||

I have attached my spreadsheet to help clear up what I am doing. Basically i want this formula to look at sales/m (sales per month) then check the sale $ (price), and return a buy price based on a certain margin range. the Margin % range and test columns ... Read MoreKatrina-
Try using a lookup table instead it will greatly simplify your formula (I've attached an example file for your reference):
=IF(A2>20,ROUNDUP(B2*VLOOKUP(B2,$K ... Read MoreBest Response confirmed by katrina bethea (New Contributor)
| |||||||||||||

You can use the Concatenate Function or the & Operator like follows:
=B2&A2 =B2&" ("&A2&")" =CONCATENATE(B2,A2) =CONCATENATE(B2," (",A2,")")
Please see example f ... Read More | |||||||||||||

Hi - I have a spreadsheet with dates that we expect materials to arrive from different vendors on a project. Hoping to add a formula that looks at a series dates in non-sequential columns and adds the latest date in the series to the column with the form ... Read MoreSteven-
Can you please provide a non-sensitive example file so the community can better understand how the data is stored/represented. The more detail you can provide ... Read More | |||||||||||||

How would I solve for an growth rate using two inputs: today's value (payment) and the sum of a stream of payments?
For example: what growth rate is required to make today's value of $100 equal $700 over the next 5 periods?
I can use the backsolve funct ... Read More | |||||||||||||

Hi all
Is this possible?. I would like to add several cells together then add "5" to the total if one cell contains the text 'yes'.
I have so far
=SUM(B1,C1,D1,E1)
please help thanks Read MoreHi, to all!
You can use this formula (non CSE formula):
Blessings! Read MoreHi, Hi,
Yes, this is possible!
Try this formula:
=IF(SUM(IFERROR(SEARCH("yes",B1:B10),0))>0,SUM(B1:B10)+5,SUM(B1:B10))
Best Response confirmed by Titchard Family (New Contributor)
| |||||||||||||

Hello,
I am trying to create a formulae that allows automatic calculation of an employee's incentive bonus.
An example of what I am trying to create is as follows:
The employee will receive graduated incentive bonus monthly once their generated revenues r ... Read MoreDear All, Could you help me to creat a formulae in Excel sheet as below;
If the the target achieved 100% the customer will get 1% andIf the the target achieved 120% the cus ... Read More | |||||||||||||

Hi,
I am using pivot tables to look at data from a large set and I want to sum the largest 5 values in a pivot table column and calculate it's % of the total of that column. If the range was static then I would just use SUMPRODUCT(LARGE(AD5:AD22,5)) and ... Read More | |||||||||||||

Hi everyone,
I currently haveca pivot table set up with a slicer and would like to apply conditional formatting to this but whenever it's filtered the formatting stops. Is there any way to fix this? I'm currently attempting to try and use a formula to selec... Read More | |||||||||||||

I have made an excel tracking document to track learners exams and assessments. I have set cell to turn colour depending on the percentage they achieved. What I would like to happen if the pass criteria is met in cells which is met i would like the cell t ... Read MoreHi Adam The issue is with merged cells and numbers in the cells between, you can sort it by the formula in the conditional formatting please see attached file
=SUM(COUNTI ... Read More | |||||||||||||

Hey, I’m trying to convert seconds to MM DD hh:mm:ss but it seems to confuse months and days as a date rather than a period of time elapsed.
This is what I’m playing around with https://docs.google.com/spreadsheets/d/1MPasewN64qomTNCgGEqa0QDqX1q6Zqc3OXElffZJam4 Read More
Thanks for the help..
I got this answer from a friend and it’s working well =IF(I2<60,TEXT(MOD(I2,2592000)/86400,"hh:mm:ss"),IF(I2<3600, TEXT(MOD(I2,2592000)/86400,"hh:mm:s... Read More Best Response confirmed by Courtney Enniss (New Contributor)
| |||||||||||||

Hello,
I need assistance with an Excel formula, please. I've been struggling with this for hours; your help is greatly appreciated.
I have a spreadsheet with 3 columns. The three columns are entitled "Month", "Year" and "Amount." There are about 10,000 ... Read MoreHi,
Please try this formula: =MAX(IF((E4=A2:A20)*(F4=B2:B20),C2:C20)) And find it in the attached file.
Hi
the easy way would be a pivot table. "Year" and "Month" in row area and "Amount" in values area. Change the aggregation function to "Min". Or use MINIFS(): =MINIFS(C2:C1... Read More | |||||||||||||

Hi
=ROUNDDOWN(SUM((F37/$D$24)*G37*H37*I37),0)
What I wanted to know is if it was possible to combine round formula's (or add an IF?) to this. Basically we want to keep the round down if the resul ... Read More
Thank you John!! That's perfect! I have never use MAX before! I have 1 small issue though - the default in the spreadsheet now is 1 because the formula currently creates ...
Read More
Hi, Sonia Tesolin!
You could try this formula:
or
Blessings! Read More | |||||||||||||

I have this;
I want the QOH and New qt. to multiply by the cost and keep a running total at the bottom of the column. I have no clues. Thanks, Erik Read MoreWhat about using one of the formulas below (Please see attached .xlsx file for an example):
or
Read More | |||||||||||||

I do spreadsheets for my work and on my new windows 10 when I set the column width and save and then reopen, the column widths are no longer what I set up. I make the corrections, save and close and when I reopen they are wrong again. I am confused, nev ... Read MoreDo you have a non-sensitive example file you could provide in order to help assess the issue? Or perhaps some screenshots?
Do you have Pivot Tables in the file? Somet ... Read More | |||||||||||||

I need to calculate daily totals based on the following <3,35 hours at 20 >=3,36 and <=4,45 hours at 40 >=4,46 hours at 60
Thanks for the help Antonio This formula that John Jairo Vergara Domínguez put together should work:
| |||||||||||||

I am using the INDEX, MATCH combination to find a value, but it returns #VALUE even when I press CTRL+SHIFT+ENTER. I can even open a workbook where the INDEX,MATCH formula has worked in the past, copy it to another cell and make sure the formulae are the ... Read MoreCan you please provide a non-sensitive example file that demonstrates your situation. Typically it's not necessary to use CTRL + SHIFT + ENTER in order to enter this typ ... Read More | |||||||||||||

Hello,
I am looking to format a spreadsheet so that any outliers are highlighted. These don't necessarily need to be mathematical outliers, I'd be fine doing something like "1.5x above or below average." The goal is simply to take note of anything out of ... Read More |

Top Liked Comments

Share

Popular

Learning Resources

Programs

Values

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