cos

  1. H

    Need to add or function to if function

    I have the following formula in Col G =IF(LEFT(B2,2)="UC","COS",IF(AND(B2="F22200",F2=""),"COS",IFERROR(VLOOKUP(F2,'unique Suppliers & Codes'!A:B,2,FALSE),""))) I would like the formula amended so that if Col F contains a date format dd/mm/yyyy for eg 03/04/2018 then it must return COS in...
  2. K

    Use index/match and sumifs to get a report which can be done on pivot table

    Is it possible to use a formula to return the result as per below: <colgroup><col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="112" style="width: 84pt...
  3. H

    VBA Code: Copy Column down to match with text in the next column

    Hello, I am not sure if I can use a formula or a VBA code to do this task. <colgroup><col width="64" style="width: 48pt;"> <col width="325" style="width: 244pt; mso-width-source: userset; mso-width-alt: 11885;"> <col width="287" style="width: 215pt; mso-width-source: userset; mso-width-alt...
  4. A

    Measure calculation for Individual items in Colums

    Hello everyone, I am trying to build a P&L that I can slice and dice as required. I get data for multiple sites and need to ability to into with a few clicks. I have the data in the below format: <tbody> Site Name Category Period 1 Period 2 Period 2 Period 3 Delta Drink Sales 5 10 15 20...
  5. K

    cosine power

    Hi, I'm trying to find out how to write the excel formula for cosine to power of -1 using the following as the calculation: i = cos^-1(.4529) Appreciate any help you can provide. Cheers, Kit

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top