M m9vukyem Member Jan 20, 2025 #1 Dear Sir Please Provide the Excel formula to get the Invoice No as per My Required rate of tax wise Attachments Inv No Exrtract.xlsx 17.3 KB · Views: 6
AlanSidman Well-Known Member Jan 20, 2025 #2 Join your two tables in Power Query and sort ascending. Attachments Inv No Exrtract.xlsx 29.7 KB · Views: 2
M m9vukyem Member Jan 20, 2025 #3 AlanSidman said: Join your two tables in Power Query and sort ascending. Click to expand... Thank you sir, but I need a formula
AlanSidman said: Join your two tables in Power Query and sort ascending. Click to expand... Thank you sir, but I need a formula
V vletm Excel Ninja Jan 20, 2025 #4 m9vukyemHow did You get those Your red values? My sample: Check cell F3. Attachments Inv No Exrtract.xlsx 18.6 KB · Views: 2
M m9vukyem Member Jan 20, 2025 #5 I entered Manually,at present the rate of tax under GST ACT only 0,5,12,18,28 i want to extract those invoice list separately
I entered Manually,at present the rate of tax under GST ACT only 0,5,12,18,28 i want to extract those invoice list separately
M m9vukyem Member Jan 20, 2025 #6 I need Invoice Numbers separately available in data sheet "c" Column Based on above rate of tax
M m9vukyem Member Jan 20, 2025 #8 I used Filter button in data sheet and filtered above rate of tax only and paste the invoice numbers in Inv No extract Sheet of Col A
I used Filter button in data sheet and filtered above rate of tax only and paste the invoice numbers in Inv No extract Sheet of Col A
V vletm Excel Ninja Jan 20, 2025 #9 2nd sample of show Attachments Inv No Exrtract.xlsx 20.1 KB · Views: 3