I want to get the content of a cell given its row and column number. The row and column number are stored in cells (here B1,B2).

I know the following solutions work, but they feel a bit hacky. Sol 1 =CELL('contents',INDIRECT(ADDRESS(B1,B2))) Sol 2 =CELL('contents',OFFSET($A$1, B1-1,B2-1)) Is there no less verbose method?

Excel 2010 conditional formatting: selectively highlighting duplicates. I have dates that are running off a formula in that column based on information it's collecting from other worksheets. I have another column that lists text answers based on a different formula that that column is running. Highlight Cell If Same Value Exists In Another Column Oct 2, 2007. I'm trying to do a formula without using a marco. The formula would do the following: - Highlight value in column A if the value is found in column B and on the same line value in column F and I are equal to zero; - Value in column A could match many value in column B.

(like =CellValue(row,col) or whatever)? Edit / Clarification: I just want to use the excel worksheet formulas. In short, I pretty much look for the equivalent of the VBA Cells() method as an excel Formula. It took me a while, but here's how I made it dynamic. It doesn't depend on a sorted table.

Wondering whether you need antivirus software to protect your Mac? MacOS is more secure than Windows, but you'd be wise to look carefully at your security options because Macs can get viruses. Which brings us back to your original question, about using an anti-virus program on your Mac. The answer is maybe; it really depends on how and where you're using your Mac. Let's start with why you should use an anti-virus program. Do i need to buy antivirus software for my mac free.

First I started with a column of state names (Column A) and a column of aircraft in each state (Column B). (Row 1 is a header row). Finding the cell that contains the number of aircraft was: =MATCH(MAX($B$2:$B$54),$B$2:$B$54,0)+MIN(ROW($B$2:$B$54))-1 I put that into a cell and then gave that cell a name, 'StateRow' Then using the tips from above, I wound up with this: =INDIRECT(ADDRESS(StateRow,1)) This returns the name of the state from the dynamic value in row 'StateRow', column 1 Now, as the values in the count column change over time as more data is entered, I always know which state has the most aircraft.

The Google Maps Widget provides a simple interface for viewing maps and satellite photos of locations in the US, UK and Canada. Maps can be navigated using the mouse or keyboard. Google maps widget for windows. About Google Widget Search Google over 30,270,000,000 web pages right from your Apple Dashboard. Bring the magic of Google to your Mac with the Google Widget. The Google Widget is must for any Google fans. For more info go to: GoogleWidget.com. What’s New in this Version - Updated parameters.