Hi there, Thank you very much your formula it really helps me a lot with my work. but my challenge is how can you removed the break time from 12pm to 1:30pm base on your working hours of 8am to 5pm. It really means a lot to me if you will solved my problem. please help..

I would like to plot student scores (percentiles) on a standard bell curve - is that possible to do in excel?

Hope you are still monitoring this ...
Can you tell me why this returns an error?

I'm trying to find the median price (SP) of existing homes (NewCon="No") by month.


{=MEDIAN(IF(DATE(YEAR(Closing_Date),1,1)=$G2,IF(NewCon="No",SP)))}

Have also tried: {=MEDIAN(IF(DATE(YEAR(Closing_Date),1,1)=$G2*(NewCon="No"),SP))}

I am trying to get a return value of "yes" if A1:A7 contains any text. What formulas can I use?

@jaysonI would like to get the return value "yes" if the cells in A1:A7 contain data. What formula can I use?

@MarceloPublic Sub FitPic()
'https://www.extendoffice.com/documents/excel/1060-excel-resize-picture-to-fit-cell.html
'Slight modification to resize into merged cells
On Error GoTo NOT_SHAPE
Dim PicWtoHRatio As Single
Dim CellWtoHRatio As Single
With Selection
PicWtoHRatio = .Width / .Height
End With
With Selection.TopLeftCell
CellWtoHRatio = .MergeArea.Width / .MergeArea.Height
End With
Select Case PicWtoHRatio / CellWtoHRatio
Case Is > 1
With Selection
.Width = .TopLeftCell.MergeArea.Width
.Height = .Width / PicWtoHRatio
End With
Case Else
With Selection
.Height = .TopLeftCell.MergeArea.Height
.Width = .Height * PicWtoHRatio
End With
End Select
With Selection
.Top = .TopLeftCell.MergeArea.Top
.Left = .TopLeftCell.MergeArea.Left
.Placement = xlMoveAndSize
End With
Exit Sub
NOT_SHAPE:
MsgBox "Select a picture before running this macro."
End Sub

@malikHere is an example of what that would look like. =IFERROR(VLOOKUP(A1,Sheet1!A:B,2,FALSE),IFERROR(VLOOKUP(A1,Sheet2!A:B,2,FALSE),IFERROR(VLOOKUP(A1,Sheet3!A:B,2,FALSE),"Item Not Found!")))


Essetially look in Sheet1 for this value, if you can't find it, look in Sheet2. If it isn't there look in Sheet3, and if after all of that it can't be found, tell me that the value could not be found.

I followed your instructions here, but I get ########## in my excel file. I formatted it to date time. Any suggestions?

I want to extract pincodes from this list:

Adikavi Nannaya University, Jaya Krishnapuram, Rajahmundry – 533 105, Andhra Pradesh.
Andhra University, Visakhapatnam-530 003.
Acharya Nagarjuna University, Nagarjuna Nagar, Guntur-522 510.
Dravidian University, Kuppam-517 425.

Is there anyone can help me on this?

It is almost complicated like solving the worlds problems. Just push "control, shift, c."