check value

Hello I have a code, with a loop (for...next to check lines) to check value on cell (line 1) and the next cell (line 2) to assemble them or not : Sub loop_check() Dim lastline As Long Dim i As Long lastline = Sheets("Data_Sheet").Range("A" & Rows.Count).End(xlUp).Row For i = 2 To...

Hey there, Sorry for my poor English in advance, am no native speaking and writing person. This question has to work in Excel 2007. For an sheet what we use to store the hours as an indication for what we need, I need a formula. But no idea how to get it done since my knowledge of Excel is...

Hello people, I been struggling with a function in couple of days now I hope someone can help me. I need a code that loops through sheet "mysheet1" on each row and checks the values in Columns "A" and "B" Example: (mySheet1) Columns:[ A ][ B ] ROW1: SWE...

By way of explanation, I am in the real estate business. Over the years I have found the MLS to be too one-dimensional, so I built an ever-evolving means of illuminating the ways in which markets behave. For example, consider the following array formula: <?xml:namespace prefix = o ns =...