• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Create numbers 1 to 10 in a range of cells so that individual values cannot be delete
#1

.xlsx   Excel Q1.xlsx (Size: 11.79 KB / Downloads: 8) Hi All,

Posting a challenge to solve an unique yet simple, Excel related question.

Topic is : We needed the numbers 1 to 10 in cells and we wanted to prevent anyone from inserting a row in-between the names.

Sheet is attached.

Regards
Prashant
  Reply
#2
(23-Apr-2019, 03:24 PM)prashantbverma7@gmail.com Wrote: Hi All,

Posting a challenge to solve an unique yet simple, Excel related question.

Topic is : We needed the numbers 1 to 10 in cells and we wanted to prevent anyone from inserting a row in-between the names.

Sheet is attached.

Regards
Prashant

Solution to this Challenge: 
Step 1: 
Ctrl + Shift +Down Arrow to select the blank cells from B4 to B13
Step 2: =ROW(B4:B13)-ROW(B4)+1
Step 3: CSE and there you go!! Smile
  Reply


Related Topics
Topic Author Replies Views Last Post
  Formula find unique values as highest values sourabh sharma 4 2,776 13-Jan-2020, 10:07 PM
Last Post: imexcelguru
  Formula add numbers in a cell imexcelguru 0 834 13-Jan-2020, 08:36 PM
Last Post: imexcelguru
  Formula Populate corresponding values basis of Title name and Code Lovedeep sharma 5 2,872 04-Jun-2018, 05:53 PM
Last Post: Lovedeep sharma

Forum Jump:


Users browsing this topic: 1 Guest(s)