turn on suggestions

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

Showing results for

- 249K Members
- 5,175 Online
- 57.7K Conversations

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

Showing results for

6124 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'm not the most proficient with Excel, so please be patient. In a nutshell, I have inserted an IF statement in a cell like this:
As a result, if I type in "Resize" into one cell, it autogenerates a 5 in the adjacent cell. If I t ... Read MoreHi Michael
SUM function ignores text and logical TRUE/FALSE, it sums only numbers in the range. Since you have text only it returns zero. You may convert your formula a ... Read MoreBest Response confirmed by Michael Morrow (New Contributor)
| |

I'm designing an intake form to collect demographic information. Is it possible to have the information from the form populate to another file in Excel? Basically I want to not have to manually enter the information into a master report file. Thanks! Read More | |

Hi all,
I am new here please be nice 😀. Yesterday I purchased home and student version of office and excel does not have power piviot 😑. I read somewhere it is coming for this version and I just wanted to see if what I read is true or not and if true, wh... Read More Hi Sean,
Perhaps, the Office home and student 2016 version isn't the latest version.
For more info, please rea ... Read More | |

Excel 2016 Help window pops up automatically when I call Msgbox. I have called the Msgbox in the Worksheet_Activate function. Immediately after the Msbox is displayed, along with Msgbox, Excel 2016 Help Window also opens.
I do not want "Excel 2016 Help" w ... Read More
Please show us the code located inside the Worksheet_Activate event to figure out the problem!
| |

I look for a working example of the webservice()-function of Excel. My last example with weather-infos from Yahoo endet working, because Yahoo changed die API. | |

Can anyone guide me on how to write an IF formula where I'm saying that depending on the percentage value in one cell then I will apply another percentage in another cell? i.e. if Cell E5 is between 0% & 10% apply 100% to Cell F5, If Cell E5 is between 1 ... Read More | |

Hi I'm trying to pivot a payroll report to be more user friendly to distribute to managers for checking. In the attached file, you'll see the 'sample master' tab, which is the format of the original file and a 'sample required' tab, which is the kind of fo ... Read More | |

Can´t you insert a table and then filter by colour, in your example choose yellow?
| |

Here I am attached my worksheet You may multiply your numbers on 100 and when use ISODD() function Best Response confirmed by pyajmal (Contributor)
| |

Is it possible to apply conditional formatting on predefined named ranges? Currently, the feature is not available, there is a feature request posted for the same in Excel User voice. Go ahead an vote for it to get the feature Read More
Yes, as it is PRE-defined, excel will turn it to the corresponding address.
| |

Hello, give me error "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or moving the formulas to diff ... Read MoreHi Jeffrey,
Try this:
edit: There´s more info on circular refrences here: ablebits.com
BR Casper Read More | |

Hi,
I need a VBA script that automatically searches for the word 'full' in column 'E' (from A to P) and then copies the entire row onto a new sheet. I want this to be a continuous process that I can do once a day
The original data is obtained automaticall ... Read More
Mr. Wheeler just in case you don't know how to use my test workbook... at the Top ribbon click DEVELOPER then the "Macro" at the left corner - Run the macros. or press AL...
Read More
Mr. Wheeler as promised, pls find the attached - the better codes with assistance from Mr. Man Fai Chan.
Mr. Wheeler attached is a revised sample for you to test. It can now delete duplicate range A-P. it may not be an Mr. Wheeler attached pls find a revised sample for you to test. I incorporated in it the SUB to delete duplicates in "NewSheet"
Mr. Wheeler Based on what I understand from your query, I made a sample where you can try.
It is not the best structured code but it ... Read More | |

Hello, I have a question about named ranges.
In a raw Data sheet I have a column C with sentences in it, all different sentences. | |

I'm looking for the correct formula to put into the data validation for the following scenario:
If cell F6 indicates "No" and cell G6 is blank, I want an error message to pop up saying that an entry (into cell G6) is required. Traci,
that will not work. Data validation is only for checking data that is put in a cell. You can't check for an input that isn't made. However you can use a helper cell ... Read More | |

Anonymous in Excel
, 07-31-2018
I have a worksheet that I keep track of my blood pressure readings with. It only has five columns. How can I hide or delete everything to show only my data in those 5 columns, please? Hi Andy
Here's the solution from a previous topic raised about this very same request.
https://techcommunity.microsoft.com/t5/Excel/Need-help-with-Excel/m-p/144412#M3495 ... Read More | |

So I have a problem that I cant find the solution to I have an excel line that looks like this but when it prints it looks like this some times I can get the gap to be smaller by moving the line over to cut off the y, sometimes that doesnt work, sometimes t ... Read MoreHi Jo
Can I confirm if I understand you right in that the
If so, it appears from your screen grab that ... Read More | |

So I found a website last year that did all this for me when I was trying to do it, but I cannot for the life of me remember what I googled to find this so I am starting from scratch because every thing I am coming across is not helping.
I have a list of ... Read More | |

I have a XSD file which contains a list of annotation IDs and documentation. I wanted to extract all the annotation IDs and documentations into a table. I am wondering whether I could write some excel formula to search and extract them.
XSD File Content: ... Read MoreHi,
Possible way is to use Power Query which has connector to XML files. First step is to generate XML schema for your XSD file, e.g. here http://xmlgrid.net/genXml.html ... Read More | |

Hi, whats the correct formatting to use these two functions in the same cell with a space
&=Contacts.Company &=Contacts.Name | |

Hello gurus! I need help in trying to figure out which formulas to use and how to write them to solve this Excel problem.
Sheet 1 = Candidate Info This table has 3 columns: Candidate ID, Zip Code, and EmpPref
Sheet 2 = Job Order Info This table has 3 colum ... Read MoreHi Ronna,
If return the string when it could be array formula with TEXTJOIN =TEXTJOIN(", ",TRUE,IF(($B$9:$B$28=$B2)*($D$9:$D$28=$D2),$A$9:$A$28,"")) and for counting =C... Read More | |

Hi,
Need help to solve the problem Please find the attachment
| |

Recurring problem on several computers on several versions of MS Excel. Latest is version 2016. I often times get an extra full-screen blank excel. It's completely a blank frame not a blank sheet.
It interferes especially when trying to type formulas. I c ... Read MoreI've had this problem also . . . I've tried all the various "things to try" that many people have posted here and elsewhere . . . all to no avail. No matter what I tried, ... Read MoreI am crossing my fingers, but I started to notice a 'flash' related to duplicating windows and viewing on different screens. I updated my NVIDIA driver to the new packag ... Read More
Hi Melanie
Does your workbook have Macros? It might be a window that is there to support that process? Are you able to upload a sample so we can see? Cheers Damien Read More Adding @Prash Shirolkar who might know what it is Did you find any solution for this issue? | |

I'm using the following formula and wanted to see if someone could help me tweak it a bit.
IFERROR(IF(VLOOKUP(C:C,SUMMIT!B:J,9,FALSE)+1<A2+1,"REGISTERED","NOT REGISTERED"),"NOT REGISTERED")
Column C has a code tied a person
Column A has a date of a transa ... Read MoreHi Tim,
VLOOKUP returns first found record, if your SUMMIT data is in chronological order that means the earliest registration. And your formula could be =IFERROR(IF(VL... Read More | |

I would like to display an Arrow on the cell above the cell wherever a duplicate value is found in a specified range. How can I achieve this?
You can achieve this by countif formula with conditional formatting..
| |

Hi I am trying to write a formula for conditional formatting that returns a red filled cell if the item selected matches one selected in the row above, the same row, the row below or the same column. I believe an if(iserror(match nested formula will work ... Read MoreHi Tanya,
If I understood your logic correctly the rule formula could be =(COUNTIF($B4:$AA6,B5)+COUNTIF(B$5:B$14,B5))>2 applied to your entire range. Read More | |

Hi I need to highlight a cell based on the value in another cell. I need to highlight cells in A when cells in H have a value higher than 0. I've tried the conditional formatting, but I have to do each on individually. I have also tried to copy and paste,...
Read More
Hi,
Please see this GIF to figure out how to do it.
This is the Conditional Formatting formula to quickly copy it into the formula box: =AND(ISNUMBER(H1),H1>0)
Regards Read More | |

Good day, everyone,
I have made the following Excel table:
I would like that the table would do the following: After the entry in "Entry", I would like that the column "Last" finds the latest entry before the current, and in column C, calculate de differ ... Read MoreHi Lucas,
If you mean most closest to the current record date when starting from B3 =MAX($A$1:$A2) in B3; and in C3 =A3-B3 drag both cells down
Read More Best Response confirmed by Lucas T. Faria (New Contributor)
| |

Is it possible to be able to click on a cell displaying "countifs" data to filter down to the data which has been counted? | |

I have four data columns in an Excel worksheet, B:E. Sometimes there are two identical data values in a row. This is indicated by the 2 value in column F. I'm trying to write a formula that, when there are identical data values in a row, calculates the dif ... Read MoreHi, to both!
You could try this shorter formulas: [Q2] : [R2 ... Read MoreHi,
For results in numbers that could be as array formula =IFERROR( IF( ABS( AGGREGATE(14+(SUM(B2:E2-INDEX(B2:E2,MATCH(1,--(COUNTIF(B2:E2,B2:E2)>1),0)... Read More | |

have this formula =if(or(d$11=d$30,d$11=d$31,d$30=d$31),"conflict","okay") which works just fine. Occassionally all the cells are "na" in which case I want "okay" as the result. could you help me modify formula? Hi Steve,
Do you mean "okay" if all cells are #N/A or any one of them? If the first =IFERROR(IF(OR(D$11=D$30,D$11=D$31,D$30=D$31),"conflict","okay"),IF(ISNA(D$11)*ISNA(... Read More | |

I am currently trying to write a IFS formula so that when one item is selected from a list, another cell will generate the owner of the item selected from the list. The formula doesn't show any errors, but only works with a few entries (see below); even a ... Read MoreHi Adam,
IMHO, your formula shall not work. Sheet2!F2:F22 is array itself and {} are used for the array constants, combination of the is incorrect.
Anyway, what's you ... Read More | |

I am using a spreadsheet with formulas to figure sales tax and am having issues with it rounding the figures up which is causing my accounting to be off. How do I get the formula to always round down?
My formula is =SUM(L3/1.09)
Where in there do I insert ... Read MoreHi Debbie,
You don't have to use SUM function in your formula because SUM is usually used on a range of cells to sum its values, not on a single cell.
So, your original f ... Read More | |

HI folks, I am not an excel professional so bear with me.
I use a simple spreadsheet that we've developed over the years to enter certain data into and answer yes or no questions. Based on this information, formulas in other cells calculate costs and tim ... Read MoreHi Jeffrey,
It seems that the calculation option is set to manual!
So, please go to: Formulas >> Calculation >> Calculation Options >> Automatic
Regards Read More | |

I am having to create a workbook each week that uses the same data source but changing cells. The only difference is the new data pulled each week might add or subtract a new row if there were changes during that week. Once that new row is added/subtracte ... Read MoreHi,
Without the sample file which illustrates how your data is organized it's hard to say which concrete formula to use, but in general SUMIF/SUMIFS could work. Read More | |

Need someone to verify this issue. Hi,
Not all info types of this function are supported in Excel Mobile as illustrated in this support article about the CELL function.
Regards Read MoreBest Response confirmed by LIAN CHAU PING null (Occasional Visitor)
| |

```
Hello, good evening, I need your help please; I spent 2 hours trying to make a formula in mac of si.joint and I get the error of circular formula and / or, # N / A since I tried everything and I can not get the formula I need.
The caluclo that I have to d
``` ...
Read More
Can you please clarify what is supposed to happen if both conditions are true? Is the below assessment accurate?
1. If Commission <= 500 Then ( Net Price + Shipping + ... Read More | |

SEE ATTACHMENTS I need in Excel 2010 to: 1. Tracks MDF FUNDING EARNED less PRODUCT INVOICED less TRADESHOW-EVENTS expenses not to exceed $100,000.00 each month 2. When RUNNING BALANCE does not exceed $100,000.00 each month, MDF PAYMENT = MDF FUNDING EARNED 3. ... Read More | |

Hi. I am making a spreadsheet that lists the items we service at work and shows the next service date. I have also made a word document that is to be used as a printable work order that fills with information from the spreadsheet via mail merge. On the sp ... Read More
Thank you for your reply, i will look into it :)
| |

Hi All,
I am not really sure how to explain what I want to accomplish, but I believe what I am looking to do is possible with INDEX and MATCH. Basically, I have a column of data on one worksheet that is also the same of one of the columns of data on anoth ... Read MoreMaybe just try using a vlookup:
Here is some additional info on how the function works:
https://www.excelcampus.com/functions/excel-vlookup-explained/
Read More Best Response confirmed by Anthony Smith (Contributor)
| |

I am having some issues with a formula to count multiple criteria and if today falls between dates in two separate columns. The current one I have that works is.
=countif(Services!$P:$P,”Honda”,Services!$Z:$Z”Civic) What I want to add is a countif function ... Read More Hi Lee,
It could be like =COUNTIFS(Services!$P:$P,”Honda”,Services!$Z:$Z, "Civic", Services!$S:$S,"<"&TODAY(),Services!$U:$U,">"&TODAY())Read More | |

Hi I am working on a list of new students who applied for finding a friends among students who are currently studying in my college. When the new students are matched with the old students, I want these to be copied to new sheet a ... Read MoreHI again, all in the Community. I would be so grateful for your answers. I can see that 23 people have seen. Do I have to explain my questions? Or is it not doable?
Regar ... Read More | |

What is the formula to divide words in a column to reach a percentage? For example, if the words are "One""Two""Three" I'm looking to divide the total amount of "One"and"Two" by the total amount of "Three" and "One". So if there were 1 "One", 1 "Two", and ... Read MoreThe best I can think of is the following, except I am met with the DIV/0 error.
=COUNTIFS(H2:H100,"ONE",H2:H100,"TWO")/(COUNTIFS(H2:H100,"THREE",H2:H100,"ONE")) Read More | |

Hello,
I'm having trouble with this project that I'm working on. I'm trying to make a report in which you chose a name from a drop down list and then all of the other information is filled in automaticly. But I'm also trying to make the drop downs auto se ... Read More | |

Hello I was looking about matrice, but too much complicate for me I've 4 words possible in A column
I'm looking for: For each column A value is PDR , the name at his right is display in C10 and for another PDR display in C11 and so on. A ... Read MoreHi, Igor! You could try the solution in file.
| |

I am looking for a formula to add a bunch of random numbers then subtract the lowest few If you have 10 random numbers in cells A1:A10 then this formula would do it =SUMIFS( A1:A10, A1:A10,">"&SMALL(A1:A10, 4 ) ) Note the 4 says ignore the 4 lowest ... Read More | |

Hello is it possible to set up an excel document so that one range of cells can be edited with a password and the rest of the document does not need a password? Tks cli | |

What I'm trying to do is take an excel sheet with a large amount of data over multiple years, then use that data to create multiple new excel sheets/individual files based on some unique ID. So, I'd create a new sheet for Org 1, Org 2, Org 3, etc. based o ... Read MoreMaybe I didn't describe this very well? I would think this wouldn't be an unusual task, I was just unsure about how to go about working through it. Would love any ideas. Read More | |

I know what I want to accomplish, but do not have the knowledge about how to accomplish it efficiently in Excel.
Greetings! Attaching required file as desired. Hope it helps. Thanks
- Select your data, click the Data tab (assuming you have Excel 2016/365). - Click the "From table" button. Excel asks to convert your data to a table. Check the box "My ... Read More | |

Hi,
I'm trying to recreate a formula from an excel template that a colleague uses (doesn't make sense to copy the entire template as I only need a few functions from it). I'm not copying and pasting from the template (as it then wants to link to that temp ... Read MoreHi Erin,
You use formula with structured references for Excel tables, it depends only on Table names and their column names. You don't need to drag cell with formula do ... Read More | |

Hi Apologies if this query is already answered but I cant for the life of me find it!
I want to interrogate the table for a specific search string generated from multiple drop downs and display the correct result In cell "N2".
Is "INDEX MATCH" the best wa ... Read MoreHello,
please post a data sample. Mock up the expected result, so we know what we are aiming for. You can upload a workbook to the thread here. Read MoreThe "Index Match" function is perfect if you have a double side entry table i.e. columns with options A B C D... and rows with options 1 2 3 4... (as excel itself). In th ... Read More |

Top Liked Comments

Share

Popular

Learning Resources

Programs

Values

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