Get instant live expert help on I need help with excel boolean cell

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Excel VBA not incrementing the value of a specific cell. Function SayIt(cell1 As Variant, Optional baSync As Boolean, Optional bPurge As Boolean) ThisWorkbook.Worksheets("Latest").Activate Dim Roll As Integer, result2 As String Roll = ThisWorkbook.Worksheets("Latest").Range("d2").Value ' The value of cell D1 is currently 1 MsgBox "Sayit Before ROLL " & Roll Roll = Roll + 1 MsgBox "Sayit After ROLL " & Roll End Function
Solved by A. U. in 20 mins
I have a big issue with a conditional format in which a date must reference a date that in is text format. My issue is with the boolean logic when referencing part of my data. I need a very experienced expert because some of this stuff is complex.
Solved by E. L. in 13 mins
Hi All, I have found a nice little code that allows me to insert a row when double clicking on a cell, copying contents as well. I was wondering if I could change it so it inserts a row if you click on the cell value '+' and deletes a row if you click on the value '-'? allowing me to insert and delete rows when needed. Private Sub Worksheet_beforedoubleclick(ByVal Target As Range, Cancel As Boolean) Cancel = True Target.Offset(1).EntireRow.Insert Target.EntireRow.Copy Target.Offset(1).EntireRow On Error Resume Next Target.Offset(1).EntireRow.SpecialCells (xlConstants)
Solved by T. S. in 24 mins
I have a large transaction dataset that I need to reformat to be able to analyze. My two columns must into several columns w boolean values based on transaction number. From this: to this: transaction# Item transaction# Milk Eggs Cheese 001 Milk 001 True True False 001 Eggs 002 False False True 002 Cheese I hope this makes sense...Thanks!
Solved by O. Q. in 20 mins
So the array that I'm working with is L31:V51. I'm trying to refine the information down below from K59:Q89. What I'm having trouble with is the way in which I craft my index match. To my understanding, I can trick the boolean and use multiple criteria to grab information (with an array formula), but I'm still unable to get the correct information. Is my formula written correctly? {=INDEX(M33:V51,MATCH(1,(L60=L33:L51)*(M59=M32:V32),0))}
Solved by E. W. in 14 mins