I have 4000+ rows data in one column and I want to convert every 10 rows into rows, transpose will not be useful as it is done manually and converting that lengthy (4k+) column will be a neck breaking task, Can any provide a Solution? Admin? Channel?
I have two columns in excel, one is name and other is values, but values are different How do I sort those values into 18 slots approx between 50 to 60? whose sum is 936
M delete krne k liye video dekh rhi thi to smj agya ple sari cell ko select kro drag krte hue uske bad keyboard k delete button press krdo sare serial delete hojayenge
Right click on the file, choose open with paint, press Ctr+W, type 10% in both height and width, ok the save file. It will reduce size of the file then go to Excel, Data>Data from picture
Haiii For example Diameter 20 with +/-0.020 and measured value is 19.970/19.980. Here lower value have -0.010mm deviation. Same this how can get in excel? It will be useful to me in work Please help
Click the sheet name bar and add A1000 it will come automatically
You are out of topic
In Home , you can see a option Fill. Just click on it , then click series. Then do fill required start and end serial numbers( HFIS)
❤
Thank you
❤
Thanks😊
Yes
Sequence formula (only works with new versions)
No it will work also in windows 7
type 1 then select the row wherever u want and jst use alt + EIS
SUPER BRO..I USED YOUR WORD
Type 1 in a Cell then Press Alt+H+FI+S "Step value=0" - "Stop value=10,000" Select columns and "OK"
Step vlu 0 se nh arha serial num step vLu 1 Se hi hoga
Ward file colum number type tricks de
your comment was the video I actually understood, in THE VIDEO they tried but they failed. :D :) :>
Yes
This looks complicated. Just use =SEQUENCE (range of numbers) e.g. =SEQUENCE(50) gives you a list of numbers 1-50.
What if it's 25 to 50
@@jpfuentes9360 Begin from 25,and step value give 5 or whatever you want.❤
That's why I came to comments to write the same thing
@@jpfuentes9360okay..... same problem here 😅
Thanks for this comment.....👍👍
Hi its very useful for me thanks.
You are welcome
I use subtotal in order to make more dynamic, atleast when i used filter the number adapt automatically
খুবই সুন্দর হয়েছে! 🎉
আমিও এক্সেল নিয়ে কাজ করি❤
😅😅 thanks so mush bro, aj bohot kush hu
= A1 +1
ruclips.net/user/shortsp91BUQQ4fFY?si=ahOsCz4QabscbYSV
Type 1 in the cell ..press control + enter to stay on the cell then ALT HFIS STOP VALUE 10000- columns (I struggled bfr getting it)
if I want to start numbering from 501 and end at 1000 than how do I do it?
Type 501 in a cell, then alt+H+FI+S. Step value 1 ,Stop value 1000, select columns 👍
@@riyasingh3937 thank
This is not possible for me man
=A1+1 enter
Drag until you want
Dragging is effort Use =Sequence Formula....🤷
ঠিক
Tuyệt vời ❤❤❤❤
Select any cell... Type 1.. Type =SEQUENCE(300,1) in fx... hit Enter
Can someone please tell me what you use this table for please? I am new to excel
is video ko dekho aap ke liye mene yeh video banaya hai ruclips.net/video/kzbqbRqZQAU/видео.html
Amazing.. The entire data got deleted
খুব ভাল লাগলো, দারুন
Sir how to put m2 & m3
Serial Number Type Just Second🤟
Formula. =Sequence (rows, columns)
Ex. =Sequence (10000,1)💯✅
Alt+E+I+S Se bhi ho sakta hain and edit bar main fill ke ander se series se bhi ho sakta hain naa sir
hmm kar sakte ho aur koi problem ho to comment kar ke puch sakte ho
what is for mac?
Plz don't use Background music
ok but is there any problem
@@focusinguideDistraction....🤷
@@focusinguideS
I have also do this it is not any impossible 😂😂😂
It's work thank you sir
nice
Nice one
Thanks for the comment!
What is min by nice one
I have 4000+ rows data in one column and I want to convert every 10 rows into rows, transpose will not be useful as it is done manually and converting that lengthy (4k+) column will be a neck breaking task, Can any provide a Solution? Admin? Channel?
Fill option ❤
Super
Thanks for comment!
Excel 2007 me work krega
maybe can and how do you like the video
Hi i want to know if range?
For example
1 - 100
101 - 200
201 - 300
good techer
Thnaks for comment 💖
Alt + EIS enter
Thanks
Use =sequence instead 😅
sabke paas sequence formula nahi hota
But I want select and delete sr no from 1 to 1200. Can I
Yes of course
=IF(ISTEXT(B1),ROW()," ")😂😂😂
jab column B me kuchh likhoge toh, column A me automatic serial number aa jayega | ye formula column A me lagana hai
Thanks!
Welcome!
I have two columns in excel, one is name and other is values, but values are different How do I sort those values into 18 slots approx between 50 to 60? whose sum is 936
How to do like this in mobile pls
aap is video ko dekho khas aap ke liye banaya hai
ruclips.net/user/shortsaNfBdwX5o8A?feature=share
M delete krne k liye video dekh rhi thi to smj agya ple sari cell ko select kro drag krte hue uske bad keyboard k delete button press krdo sare serial delete hojayenge
Row कॉलम दोनो मैं 100 तक गिनती लाने के लिए konsi cey hai
Row ke liye
=SEQUENCE(100)
Column ke liye
=SEQUENCE(1,100)
Can anyone suggest me background music name
Hola Como Tale Tale Vu
I know it very well 😅😅😅😅😅😅
Nice🎉
Thanks 🤗and support
1 type krke 1k corner pr plus k o niche lowge tv b ho jayga bro
Se for nas versões mais novas use SEQUENCE
Can I know you more please, I want to learn more on Microsoft world
you to learn in this channel Like a MS-office course(ms-excel,ms-word-power point, internet and e-mail Writing,Technology videos .
Alt + EIS
Alt+hfis for column numbers
Please tel me how to convert 37 MB jpg file to Excel file.... It is urgent
Right click on the file, choose open with paint, press Ctr+W, type 10% in both height and width, ok the save file.
It will reduce size of the file then go to Excel, Data>Data from picture
Wow wonderful song
How to place the serial number on the left side?
Pls explain in details in which columns you want serial number
How can I do
1
2
3
4
Jb bhi hm drag kreng 1 dalne k bad to plus sign k pas to us pr click kr k series select krenge tb bhi hojayega 😂
Thank you
Welcome!
Mast
Thanks 🤗
Haiii
For example Diameter 20 with +/-0.020 and measured value is 19.970/19.980. Here lower value have -0.010mm deviation. Same this how can get in excel?
It will be useful to me in work
Please help
Purila bro
are kehna kya chahte ho ?
Exhibition of course PPF
You have to select column… not row
Very impressive
Sir Excel table me mobile no count kese kare, reapet no. Count nhi karne
=COUNT(UNIQUE(A:A))
Thank you ❤
Welcome!
Thankieww sir😊
Excel 2007 me work krega❤
maybe try
good
Deepak Bodana 🚘❤
Why am I not getting even after trying many times
Because first you have to press 1 inside the column Then press every 4 letters with alt key. like alt + H+F+I+S
Select row of A to write the numbers along with alt +h+f+i+s
nice one
Thanks for the visit'
Babal thanks ❤❤❤❤
Always welcome
Not working in Office 2007😢
Thanks man 👍
បង្ហាញលឿនពេក
ខ្ញុំនឹងថែរក្សានៅពេលក្រោយ
😃អរគុណ.ការយកការកែលំអ
Drag chai kunta chudadam avadada anna
Shorts cut ki jagah bol dety fill option Pey Click kro kitna Confusion Kr Rahy Ho
Thanks
Nice
Thanks
Alt+E+I+S
Short than it
elaborate it please
Irritating music..why?
Song name?
Hola Como Tale Tale Vu
There was no better song.
If you can suggest some songs
আসসালামু আলাইকুম ভাই। ইসলামী গজল দিয়েন।
আল্লাহ আপনার মঙ্গল করুক এবং ইসলামের উপর অটুট থাকার তোফিক দান করুক আমিন। ইনশাআল্লাহ।
Alt+E+I+S
ALT EIS
Rose is red
Sky is blue
I got scam
He/she got views
So,it is fake and fake
Is it fake🙄
It doesn't work on mine
Its working mam
Alright, I'll be back after trying it. Thanks anyway!
It's not a fake, It's work
type 1 in a cell then press Alt+H+F+I+S , open a New window then step value type 1 and stop value type 10000 then press ok
You can not serious 😅😅😅
BIG LIKE
it's not working in google sheet
Firs you watch the video properly
Nahin Ho pa raha hai counting
Olunga podunga da
Cukup ('1) klik 2x pada kolom
Instead do this =""&SEQUENCE(1000)
What is this, who made this video, why that worse background noise, is it any relationship with this
👍👍👍👍👍
please support me and any problem so comments
Alt+f5
Hm se ni ho pa rh h
Useless music. Ruining the whole thing 😢
Alt EIS
It's really
yes it's work
Hello