Excel wala row multiple row numbers dila filter krnna puluwnda?

[batwise]

Excel wala multiple row numbers dila ita adala rows tika wtrk filter karaganna widihak tianwada?

Oya highlight karala tiana row numbers walin, oke rows 1000kata kittuwa tianawa, eka para rows 100k wtra filter karala ganna ona, row numbers walin. numbers 100k enawa.

wenama column ekk dala , eke numbers walin hari awlk na, eka para multiple rows 100k wage ganna ona,

ex. 1,5,6,8,10,20 kyala filter karama, ita adala rows 6 display wenna ona. (oya wage eka para 100k wtra filter karaganna ona.)
CSV karala sql dala pulwn,
excel ekema oka krnna widihak tianwada?

 

[PHBhagya]

බම්ප්

 

[shenat]

Pahadili na kiyala tiyena eka. Oya dala tiyena screenshot ekenma example eka kiyanna balanna.

 

[ArunaTelshan]

Puluwan, row formula eken row number eka aran filter karaganna ouata ona range eka select karala

 

[batwise]

Puluwan, row formula eken row number eka aran filter karaganna ouata ona range eka select karala

eken dala rows tika wtri output karaganna puluwnda?

---

Pahadili na kiyala tiyena eka. Oya dala tiyena screenshot ekenma example eka kiyanna balanna.

excel sheet ekaka rows 20k tinawa kyamuko, eken mata row number 5,6,7,10,12 wtrk output karaganna ona. eka krnna widihak tianawada kyala baluwe.
------ Post added on Jun 26, 2021 at 9:10 AM

 

[wqe123]

custom filter daala range ekak nam select karanna puluwan.
Eg 101-201 wenakan

ehema nathi nam drop down eken select karanna thama wenne eka nam practical naa...

 

[batwise]

custom filter daala range ekak nam select karanna puluwan.
Eg 101-201 wenakan

ehema nathi nam drop down eken select karanna thama wenne eka nam practical naa...
View attachment 132686

ow , meke ekin eka select karanna ona hinda amarui ne, 100k tianwa, wade karagatta.

---

mata excel eke row numbers tika ganna widihk tibba, eka note pad ekakata dala me format ekata

ita passe eka paste kara

otena, left side eke udama tienne.
ita passe enter karama ekata adala cells tika highlight wuna, e tikata color ekk dagena, table sorter eken e color ekata adala tika sort karan, wenama sheet ekata copy karala gatta rows tika.
------ Post added on Jun 26, 2021 at 9:33 AM

 

[wqe123]

ehema nam vlookup ekak daala aluth column ekakata. eka filter karanna puluwan ne without blank kiyalaaath
.....

 

[hodakolla]

BUMPER