Custom List Message Item | |||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Hi there!
Does anyone has an idea how this could be solved? I have Office 2013 :) Hi Marco,
If with formulas you may add =OFFSET($A$1,MOD(ROW()-1,7),INT((ROW()-1)/7)*4+COLUMN()-1) into A8, copy it to the right till D8 and when copy down A8:D8 till en ... Read More
Do you still want to keep those columns (from the 5th to the last)
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hi. I’m new to the community (and a bit of an excel amateur). Just joined as I have an issue which I think is quite simple, but to which I can’t find a solution. Basically I’m trying to add up hours worked, and then multiply those hours by an hourly wage. ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
I am struggling to know what formula will allow me to highlight employees who are late.
Regards
Declan Hi,
If you mean to highlight their names apply the rule =$E4="Late" to your B columns (attached)
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hello,
I am trying to write a formula that will work with the following: If we say that 'product' is cell A1
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hi all,
So I'm making a personal timesheet from, nearly, scratch and I need a hand with one problem I'm having.
I'm a casual worker and have two different levels of overtime, 1.5x and 2x for which there is a column each. 1.5x hits when I do a shift ov ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hi All, Am trying to populate monthly data, for a number of projects which have different start & end dates. The monthly data the revenue expected for each month. This is calculated by looking up a % revenue expected per month ( from another table) X t ... Read MoreHi @Neale Forth
I hope I have understood right. Please see the attached file to see if what I have interpreted is correct?
Cheers Damien Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hello,
I am attempting to pull in some information located on a website into one of my workbooks. Normally this is not an issue but the site only loads in compatibility mode and excel will not recognize all the information, and the only information I ne ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hello,
I'm trying to build a formula that will allow me to do a vlookup/sumifs using a lookup value with a "zero" as the last character of the code/lookup value. However, the formula is currently ignoring the zero. So I get the same result for 12345.1 ... Read MoreIf these numbers are treated as actual numbers, it is normal to get the same result! There is no difference between this 12345.13 and this 12345.130, since the Trailing zeros ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hi Excel-Community, We're in the process of updating our current multi-currency pricelist with the new prices for 2018. Following is an example of the expected result.
This being said we don't arrive to create a multiple lookup to match the Part# with ... Read MoreHi,
You can use one of the below formulas: =VLOOKUP(B2,$G$3:$I$6,IF(A2="XY",2,IF(A2="XYZ",3,NA())),0) =INDEX($H$3:$I$6,MATCH(B2,$G$3:$G$6,0),MATCH(A2,$H$2:$I$2,0)) Plea ... Read MoreBest Response confirmed by Benjamin Aebischer (New Contributor)
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hello excel Gurus,
I'm looking for help with writing a formula in a current workbook. I need a formula that will look up information in multiple tabs, and return one or multiple values into another tab.
I have created a smaller version of my workbo ... Read MoreAshley,
I made the formula almost completely dynamic but it still depends on the order of customers and the order of columns in the "Display" sheets. It also depends on ... Read MoreBest Response confirmed by Ashley Tanay (New Contributor)
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hi Folks - frustration on a simple? issue of sorting by days | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hello,
I'm having trouble using the IF function. I would like to show the value of a cell, but also apply the IF function. Is this possible?
Here is the statement I'm using: =(G3-G2)-G6,(IF(G7<0,B9+G7,B10+G7))
What am I doing wrong?
Jesse Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Morning Everyone,
Continuing on my price quote form. So far, I've used "form controls" option button. I can't adjust the font size or type but in the "ActiveX Controls" option button, I can. What are the Pro's and Con's to each? How can I change the ce ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hi experts i have some questions please help
How can i connect 1 excel workbook with another excel workbook that will be placed in google docs or any web hosting.
What exactly i want. I want to keep 1 excel workbook in a laptop and 1 connected workboo ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hi ,
i would like to have a formula to count the repeatations time of name bobby in a column B1:B200, if the date in the columns A1:A200 contains today's date. I tried the countif and if in a nested way but something is wrong. Read MoreRajesh,
neither function will help. =COUNTIFS(B1:B200,"bobby",A1:A200;TODAY()) Best Response confirmed by Rajesh Kumar Bhupal (New Contributor)
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
I'm trying to use the weeknum function but there is no return type that make week 1 the first full week of the new year. Is there a way to get around this?
Henry,
could you explain where such a system is used? Excel only uses two systems according to the support page.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hi All,
I work at a company that does custom fabrication using various type of plastic sheets, acrylic, ABS, PolyCarbonate,...etc. I am creating a form for our counter staff to use to calculate easily, pricing based on number of pcs, size of pcs, thickn ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Multiple Table Cross Check Answers then Compare answer between the 2 table With conditional formatin
Hello,
your sample file has links to an external file. Please upload a file without external references. Right now it is not clear what you want to achieve.
It may be ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
NEED HELP I have a master file of chart of accounts and accounts are created monthly. How do I set the excel worksheet to highlight new accounts added to the list of chart of accounts? See attached example excel file.
Read More Hi Sophia,
Excel itself has no idea is that a new record or not, you need to help it. For example add one more field when the account was added and highlight all record ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hello, I am working right now with an Access Point Report. They ask me to take out how many Hours a day a person works having this table:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
Trying to form a formula that picks up data from other cells. The values in the other cells are from formulas.
eg AA1: formula =if(B1=C1,"ok","check"), My formula in another cell is supposed to pick up the OK or check. If(AA1=BB1="ok","ok","check") but cur ... Read More
You only ran into a syntax error. The formula is simply:
=If(BB1=CC1,"OK","Check") Instead of =If(BB1=CC1="OK","Check") Hi Ghada,
You formula first checks if AA1 is equal to BB1 and returns TRUE or FALSE (1 or 0) and after that compare with "ok". That is always FALSE, thus the result is al ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hello, I try to transcribe these conditions with an IF but an error message appears that I don't understand
Yamina,
two alternatives.
Best Response confirmed by Yamina Azri (New Contributor)
Hi Yamina,
I hope it will help ... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
I am using Excel 2013 and trying to create an IF forumula: I have a drop down list of 32 items in Cell F9. If they selection one of the first 16 I want to multiply Cell M9 by 1. If they select one of the second 16 I want to multiply cell L9 by Cell M9. ... Read MoreGiven that your drop-down list source is in O9:O41 (which is 33 cells not 32), then you can use the MATCH function to return the position of your F9 selection within the ... Read MoreI advise you to depend on the source of that drop-down list in the logical test as shown in the below screenshot:
This is the formula: =IF(F19<>"",IF(OR(F19=A1:A16... Read More | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hello,
We have a work contest this month and I would like to create a spreadsheet to track my progress and my competition.
We earn one point for our daily goal of 6, then 1 more point per additional unit over 6. For example, if you sell 14 units in ... Read MoreAssuming all of your numbers are whole numbers starting in A1 then a simple IF formula in B1 should work: =IF(A1>5, A1-5, 0) Katelyn,
a more advanced solution: =MAX(0,A1-6+(A1>=6)) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Hi folks, I am preparing for Excel exam MOS 2016, while I was practicing using a demo exercise, I saw this question, which I am not happy with the way the answered it.
Insert a formula into cell G4 that evaluates whether the amount is Parts, Accessories ... Read MoreUse the SUMIF formula:
In G4 enter =SUMIF(B4:D4,">"&$B$18)*$B$17 If you then drag this formula down the references to B4:D4 will increment to B5:D5 while references to ... Read More |