Averaging & Assigning Blank Cells a Specific Numeric Value
Closed
averagejoem
Posts
2
Registration date
Thursday July 11, 2013
Status
Member
Last seen
July 12, 2013
-
Jul 11, 2013 at 05:56 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 13, 2013 at 12:10 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 13, 2013 at 12:10 AM
Related:
- Averaging & Assigning Blank Cells a Specific Numeric Value
- How to find specific words on a page - Guide
- Numeric to words in excel - Guide
- Based on the value in cells b77 b81 ✓ - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 12, 2013 at 07:51 AM
Jul 12, 2013 at 07:51 AM
suppose your data is in A1 to E5
try this macro
if data is differnt modify r=
FEEDBACK PLEASE
try this macro
if data is differnt modify r=
Sub fillin_blanks() Dim r As Range Set r = Range("A1:E7") r.SpecialCells(xlCellTypeBlanks) = 201 End Sub
FEEDBACK PLEASE
averagejoem
Posts
2
Registration date
Thursday July 11, 2013
Status
Member
Last seen
July 12, 2013
Jul 12, 2013 at 06:24 PM
Jul 12, 2013 at 06:24 PM
Your suggestion is greatly appreciated, but unfortunately it is over my head as well. I was hoping for a nested formula that I could paste at the end of each row? I'll try your suggestion, but I don't have much experience with macros. Plus when I'm finished I was going to pass this spreadsheet onto someone else with even less Excel experience. I do thank you and appreciate the reply.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 13, 2013 at 12:10 AM
Jul 13, 2013 at 12:10 AM
highlight the data
1.click function key F5
2.click "special" in left bottom
3. choose blanks
4.click ok
all the blanks cells will be selected
4.in the first cell enter any value e.g. 121. DO NOT HIT ENTER
5.HIT CONTROL+ENTER
DO U GET WHAT YOU WANT?
1.click function key F5
2.click "special" in left bottom
3. choose blanks
4.click ok
all the blanks cells will be selected
4.in the first cell enter any value e.g. 121. DO NOT HIT ENTER
5.HIT CONTROL+ENTER
DO U GET WHAT YOU WANT?