complex calculations

  1. K

    Formatting table using VBA- Need help!

    Hi, I've been trying to get this done to analyze the data. However, I am unable to un-pivot this table. Could someone please guide me here? Input table- <tbody> A A A A A B B B B B WEEK MON TUE WED THURS FRI MON TUE WED THURS FRI 1 100 100 100 100 100 100 100 100 100 100 2 150 150 150...
  2. S

    Need help understanding SUBSTITUTE MID SUBSTITUTE REPT formula

    So yeah surprisingly I didn't find any explanations on this semi complicated formula =SUBSTITUTE(MID(SUBSTITUTE("_" & B7&REPT(" ",6),"_",REPT(",",255)),2*255,255),",","") So here I used it to extract a value between "_" characters. But I want to make other additions/operations to this formula...
  3. H

    Another complex working hours formula

    Hi! I am creating a template which consists the following: Start Date & Time - contains a start date and time End Date & Time - contains a end date and time nwday1 - Named range (contains non-working 1 day OR first weekly off, it accepts a number from 1 to 7) nwday2 - Named range (contains...
  4. I

    help in summation

    hi, thanks in advance, and pardon me for my english, i am trying to make an excel sheet to keep my inventory of my company i have a large no of products, here, what i m trying to do is >>i have a sheet(diamond) which has details of the diamonds where i have shape, size, weight, price...
  5. G

    Powerpivot Weighted Average Measure

    Hello, I have a data that calculates forecast accuracy. I have this as a measure - the measure formula is...
  6. D

    Find most recent date in one range based on criteria, then return column from that row

    I couldn't think of a simpler way to title this :eeek: Here's my issue - I've got a table of expenses from the year, I want to get the final balance for the month from the balance column for each month. I've already created a reference cell for the first and last days of the month for something...
  7. N

    Display minimum of numbers or text if range criteria is met

    =IF(AND(A4:A6>=0,A4:A6<=5,COUNTIF(A4:A6,"NS")),MIN(A4:A6),"NS") This equation doesn't seem to capture the full logic of what I'm trying to accomplish. In column A, we have a validated data cell where the only allowed values are: 1,3,5, NS. In the column where the above equation fits, I would...
  8. A

    VLOOKUP with INDIRECT

    Hi Guys, I'm using this forumla; =IF(ISNA(VLOOKUP(A3,(INDIRECT("'"&A5&"'!"))$A$6:$F$2560,6,FALSE))=TRUE,"Employee not found",(VLOOKUP(A3,(INDIRECT("'"&A5&"'!"))$A$6:$F$2560,6,FALSE))) in an attempt to read from the array in the tab named in cell a5. I get a formatting error when i input it...
  9. S

    Is it possible to do this in Excel..

    Hii, I am an average good user of excel, till now I have been able to solve all kind of complex calculations some way but I have encountered a situation & wondering if there is any way to do this in excel or using some VBA. I would be grateful to all of you for this. My excel sheet is some...

Some videos you may like

This Week's Hot Topics

Top