User Profile

Gaurav_Jalan

Copper Contributor

Joined Mar 17, 2019

6 Posts1 LikeLikes received

View All Badges

User Widgets

Recent Discussions

Re: Pivot Table Formatting
hello Try to change the Report layout to table format , Design > Report layout > Tabular format Keetonct
Mar 23, 2019 Place Excel
1.8KViews
0likes
0Comments
Re: Convert A Chart
Use pivot table instead using any formula , still you want to use formula define a value on which base you want to see that report like date , model number or any other head then u can use formula for making such reports, but i suggest to use pivot tablemohsin91santono-_-1220
Mar 20, 2019 Place Excel
1.4KViews
1like
1Comment
Re: Excel freezing
Hello Save your excel file as Excel binray workbook (.xlsb) , this can reduce your size of file without any harm to data. Aslo this makes your processing fast. VVshved
Mar 19, 2019 Place Excel
741Views
0likes
0Comments
Re: Entering Customer details in an invoice
Hi mick Use Vlookup Formula if you have a separate database of customer with id , then by using vlookup formula you can fetch the data easily Like : =vlookup(Cus_id,Database Array,Col index,0) Mick15
Mar 18, 2019 Place Excel
1.2KViews
0likes
1Comment
Re: Counting the number of rows by text value
hello Shared two images hope you find the solution Jenny-Amari
Mar 17, 2019 Place Excel
1KViews
0likes
0Comments
Re: How to make pivot table count the due for revision which pass this month march 2019
Hello Emma you have to change the field settings individually to the tabular form & also put the "due for revision in the row column of pivot fields please check the file i did some changes, hope it will help you in solving your problem emma1231570
Mar 17, 2019 Place Excel
725Views
0likes
0Comments

Recent Blog Articles

No content to show