1Library QA - where all data is collected and answered in all fields

AG

If anybody interested to learn Excel (basic and top 25 most commonly used formulas in Urdu/Hindi), they are highly encouraged to check this video

If anybody interested to learn Excel (basic and top 25 most commonly used formulas in Urdu/Hindi), they are highly encouraged to check this video: Don't hesitate to ask (inbox) for Practice file

25 104

AG

Don't remain stuck to the formulas, try Power Query (Built-in official Add-in within Excel, nothing to installed if you're using Excel 2013 or later) and automate your reporting.

Created 3 years ago

Don't remain stuck to the formulas, try Power Query (Built-in official Add-in within Excel, nothing to installed if you're using Excel 2013 or later) and automate your reporting. One time transformati...

1 1

AG

What is wrong with my GetPivotData Function?

Created 2 years ago

What is wrong with my GetPivotData Function?

25 16

AG

ANYBODY'S INTERESTED TO LEARN "PIVOT TABLE" (IN URDU/HINDI)?

Created 2 years ago

ANYBODY'S INTERESTED TO LEARN "PIVOT TABLE" (IN URDU/HINDI)?

25 277

AG

I have 2 cells (B2 & D2 on sheet named "daily consumption", these cells are drop-downs and are creating an address of a file/sheet which is then connected to query in Power Query) I want to refresh my query if any

Created 1 year ago

Hello Everyone, I need help! I have 2 cells (B2 & D2 on sheet named "daily consumption", these cells are drop-downs and are creating an address of a file/sheet which is then connected to query in...

5 7

AG

Anybody's interested to learn VLOOKUP in Power Query?

Created 2 years ago

Anybody's interested to learn VLOOKUP in Power Query? **Edit: Thanks for the overwhelming response, I am bared to respond any more by FB, you guys can check this video and inbox me any further questi...

25 365

AG

Hello everyone, I see alot of people post their questions and attach photos taken with their phones which are often very hard to read for the experts.

Created 3 years ago

Hello everyone, I see alot of people post their questions and attach photos taken with their phones which are often very hard to read for the experts. I have been using a free utility (Both for PC and...

5 10

AG

Hello everyone, just letting you know if anyone tries to post any irrelevant link will be removed from the group without any warnings, apologies but we are tired of deleting the non-serious posts.

Created 2 years ago

Hello everyone, just letting you know if anyone tries to post any irrelevant link will be removed from the group without any warnings, apologies but we are tired of deleting the non-serious posts. tha...

REPT Function

25 10

AG

Stop considering yourself an average Excel user, if you can use lookup, conditional, count and sumif formulas, know a bit about pivot tables, you're already an Excel Expert and it's time to take a step further and

Created 3 years ago

Stop considering yourself an average Excel user, if you can use lookup, conditional, count and sumif formulas, know a bit about pivot tables, you're already an Excel Expert and it's time to take a ste...

5 1

AG

#needhelp Trying to make the ending cell (highlighted in yellow in the attached screenshot) in the ranges dynamic (non-empty/last cell in each column instead of fixed) , any help would be highly appreciated.

Created 1 year ago

#needhelp Trying to make the ending cell (highlighted in yellow in the attached screenshot) in the ranges dynamic (non-empty/last cell in each column instead of fixed) , any help would be highly appre...

needhelp

2 12

Abdul Ghaffar

If anybody interested to learn Excel (basic and top 25 most commonly used formulas in Urdu/Hindi), they are highly encouraged to check this video

Don't remain stuck to the formulas, try Power Query (Built-in official Add-in within Excel, nothing to installed if you're using Excel 2013 or later) and automate your reporting.

What is wrong with my GetPivotData Function?

ANYBODY'S INTERESTED TO LEARN "PIVOT TABLE" (IN URDU/HINDI)?

I have 2 cells (B2 & D2 on sheet named "daily consumption", these cells are drop-downs and are creating an address of a file/sheet which is then connected to query in Power Query) I want to refresh my query if any

Anybody's interested to learn VLOOKUP in Power Query?

Hello everyone, I see alot of people post their questions and attach photos taken with their phones which are often very hard to read for the experts.

Hello everyone, just letting you know if anyone tries to post any irrelevant link will be removed from the group without any warnings, apologies but we are tired of deleting the non-serious posts.

Stop considering yourself an average Excel user, if you can use lookup, conditional, count and sumif formulas, know a bit about pivot tables, you're already an Excel Expert and it's time to take a step further and

#needhelp Trying to make the ending cell (highlighted in yellow in the attached screenshot) in the ranges dynamic (non-empty/last cell in each column instead of fixed) , any help would be highly appreciated.