• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Condition based status update
#1
I have "8 Step" wise cell, now I want to put any value in 1- step to 8- step then my status is "complete"
if I update the value in any mid of step that step are show in status…(like given exmpl)

date are less then & greater than both way are coming


Attached Files
.xlsx   Book1.xlsx (Size: 9.1 KB / Downloads: 13)
  Reply
#2
Hi Dharmesh,

Pfa..


Attached Files
.xlsx   Book1(5).xlsx (Size: 9.55 KB / Downloads: 10)
  Reply
#3
Thanks Mohit..

But I want to put STEP name in status... which step is done after complete all step its show complete.
  Reply
#4
Hello Dharmesh,

please find below formula

=IF(COUNTA(B6:I6)=0,"NA",IF(COUNTA(B6:I6)>=8,"Complete",INDIRECT(ADDRESS(5,COUNTA(B6:I6)+1))))


Attached Files
.xlsx   STEP.xlsx (Size: 9.58 KB / Downloads: 3)
  Reply
#5
(13-Oct-2017, 11:47 PM)Lovedeep sharma Wrote: Hello Dharmesh,

please find below formula

=IF(COUNTA(B6:I6)=0,"NA",IF(COUNTA(B6:I6)>=8,"Complete",INDIRECT(ADDRESS(5,COUNTA(B6:I6)+1))))

INDIRECT(ADDRESS(5,COUNTA(B6:I6)+1))))

Lovdeep can plz little bit brief over the INDIRECT use... I m little confuse of INDIRECT use..
  Reply
#6
Indirect is useful when you want to convert a text value into a valid cell reference.
For example, formula =INDIRECT(ADDRESS(5,COUNTA(B6:I6)+1)) will always refer last entry field name
  Reply
#7
and whats about the "ADDRESS(5"

I can't understand use of "5" if its row no so plz explain...
mai samjh nhi paya ki yha pr aap ne 5 kyo use kiya h
  Reply
#8
Please find attached SS


Attached Files Image(s)
   
  Reply
#9
PFA...


Attached Files
.xlsx   SOLVE.xlsx (Size: 10.45 KB / Downloads: 5)
  Reply


Related Topics
Topic Author Replies Views Last Post
  Others If & And Condition Anil Kumar Pal 4 2,033 21-May-2019, 02:50 PM
Last Post: Anil Kumar Pal
Bestseller Formula Lookup query - based on multiple conditions Amit Rawat 2 2,002 16-Jul-2018, 05:05 PM
Last Post: Amit Rawat
  Pivot Table How to make pivot on below condition Anil Kumar Pal 1 1,525 16-May-2018, 01:00 PM
Last Post: Vivekananda Sinha
  Conditional Formatting Condition Formatting PRADEEP RASTOGI 3 2,440 20-Feb-2018, 10:12 PM
Last Post: sanj_edu
  Conditional Formatting Condition Formatting PRADEEP RASTOGI 1 1,882 11-Jan-2018, 08:54 PM
Last Post: sanj_edu
  Data Validation Drop Down with condition Dharmesh Kumar Srivastava 2 2,252 29-Dec-2017, 09:09 PM
Last Post: sanj_edu
  Conditional Formatting Count of duplicate value as single, on condition based Dharmesh Kumar Srivastava 1 2,006 18-Oct-2017, 04:04 PM
Last Post: Mohit Sharma
  Conditional Formatting condition formatting Angad Singh 1 2,013 02-Sep-2017, 08:26 AM
Last Post: Vivekananda Sinha
  Conditional Formatting condition format Yogesh kumar 1 2,278 10-Jul-2017, 08:02 PM
Last Post: Lovedeep sharma
  Formula Sum & If in double condition Gaurav Agarwal 2 2,519 06-Jul-2017, 06:28 PM
Last Post: Vivekananda Sinha

Forum Jump:


Users browsing this topic: 1 Guest(s)