1. T

    Forumla Help

    I know this is probably something simple that I am just not thinking of but I'm struggling here and wanted to see if I could get some advise! I have imported sales data into a spreadsheet over a large period of time, it has imported at one day per tab and has 133 tabs of unique data. I need to...
  2. H

    Combining 3 x INDEX MATCH

    Hi All, I have a column with INDEX/MATCH formula, but the match value could come from 1 of 3 possible columns. Could you help me combine the below into one formula please? =IFERROR(INDEX(admin!$C$4:$C$100,MATCH(C4,admin!$B$4:$B$100,0)),"0")...
  3. H

    combining formula

    Good day Here is my code =IF(ISNUMBER(SEARCH(substring,text)), "Yes", "No") The result is in C6 (empty cell). When I put a number in A6 (empty cell). Then the empty cell C6 show the result. The substring is in B3. How to combine formula with my code above thank you
  4. D

    Using If, Left and Or Functions

    Hello, I'm trying to get a formula with multiple conditions to work and am having a hard time. Basically: If A1 starts with "ABCD" OR "EFGH", put the value (say, $10) of B1 into cell C1. If A1 starts with anything else, put a zero in cell C1. I've tried combining If, Left and Or but I must be...
  5. S

    Combining IF(OR & IF(AND Statements

    I have the following statements that ascertain whether a 1 or 0 is shown in a destination cell. I have been trying to combine both statements with no luck. =IF(OR(T29="W"),1,ROUNDDOWN(COUNTIF(T29:T33,"W")/2,0)) =IF(AND(T29="W"),ROUNDDOWN(COUNTIF(AR29:AR33,"W"=2),0)) Is it possible to combine...
  6. J

    Search a phrase in a sheet then display that phrase in the cell

    Hello, I am trying to figure out a formula which will search a separate sheet for four different phases. Then, display the one phrase that is in the sheet. I need to search the exact phrase and the cells it is search will only contain that phrase ( i.e. I’m not search a paragraph of text) I...
  7. H

    Combining excelsheets with different coloumn names into one.

    I have an excel with diffent sheets having data, with different column names, i want to merge this into one? Please help me on this
  8. B

    Help combining calculations containing absolute references

    Hello there, I have the following formula: =SQRT(SUM($N$2:$N2)/SUM($G$2:$G2)) Column 'N' refers to a simple calculation: = B2*B2*G2 Can anyone supply a simple method of combining the calculation in column 'N' directly into the original formula? Thanks in advance, B.
  9. S

    Combining Formulas

    Hey all, Hopefully a simple question for you lot but unfortunately not for me! =IF(INDEX(T:T,MATCH(E5,AF:$AF,0))=H5,"Yes","") =IF(INDEX(S:S,MATCH(E5,AF:$AF,0))=G5,"Yes","") I have the above formulas in two different cells but I'm wanting to combine them both together. So that if both are...
  10. O

    Combining Two Ranges together.

    Hey excel Gurus, How do you combine 2 different ranges together with a With statement. With Range("A2:A1000" & "U1:FO1") is the above correct? thank you.
  11. S

    combining formula in one

    i have the formula which checks 5 criteria and 2 formula check the other 2 column which i put by (ctrl+shift+del) can we combine both the formula 1. formula...
  12. T

    combining cells

    is there a way to combine two cells info into one? if cell "A" has the word "happy" and cell "B" has "feet" cell "C" will say happy feet.
  13. H

    Assistance Combining Two Codes

    Hi I have 2 lots of code that I need to combine to give a result, but it is beyond my skill to do it. I assume it will be using OR somehow, but just not 100% exactly how to do it. =IF(AND(G1256="LOST",F1256<=10),95,0) =IF(AND(G1256="WIN",F1256<=10),-100*F1256+100,0) Both sections seem to work...
  14. D

    Combining formulas

    I am combining data in several columns into one singlecolumn using this formula: =OFFSET(AccRange,MOD(ROW()-ROW(ColumnData),ROWS(AccRange)),TRUNC((ROW()-ROW(ColumnData))/ROWS(AccRange),0),1,1) I’m using named ranges: AccRange = columns I’m combining; ColumnData = column where I’m placingall my...
  15. M

    Combining Sumifs Help Please

    Hi Is their a way to rewrite these 2 sumifs (array) into 1 so that I would have 4 conditions? =SUM(IF(($H$2:$H$2634<$N3)*($H$2:$H$2634>=N4),$G$2:$G$2634,"")) =SUM(IF(($A$2:$A$2634<$O3)*($A$2:$A$2634>=O4),$G$2:$G$2634,"")) Thank you! MM
  16. K

    Combining IF's?

    Greetings! I've searched around for combining IF commands for a single cell but I may be using the wrong termonology because I am not figuring it out. . I need to query one cell and display the result on the next tab. I believe my functions are the best for this but I am unable to combine them...
  17. V

    Combining two IF statements

    =IF(AND(C1<>"B",B1<0),50,40) =IF(AND(C1="B",B1<0),40,50) Urgently need guide on how to combine above two IF statements into one.
  18. H

    combining vlookup function

    Good day, I need to combine this function with vlookup. Due to i need to ensure no bar code data are missing if something occur while handling this. =IF(A10="","",IF(A10='BARCODE REGISTER'!A10,"PASS","NG")) So if someone scan without follow the sequence number. The bar code will also detect...
  19. S

    Combining multiple Microsoft Excel Comma Separated Values

    Hi everyone! Please help me with combining multiple Microsoft Excel Comma Separated Values, I want to combine my 40 csv files in one excel without opening and copy paste them one by one, and everyday our production machine producing this csv file.After creating a macro tool, I hope this tool...
  20. D

    Number to date conversion

    In A1 I have 43244 Software Application. I want it to be 24/05/18 Software Application. I thought combining TEXT and LEFT would work but it doesn't.

Some videos you may like

This Week's Hot Topics