入黎免費幫你砌excel表 / 教你formula (6)

浮浪者 2021-4-14 19:56:35

:^(

Captain_Deadline 2021-4-14 20:01:34 此回覆已被刪除

膠化鳥 2021-4-14 20:12:57 留名學

傅家俊 2021-4-15 03:43:23 VBA
d code我Google搵，懶得打

Sub SaveAsPDF()

    Dim CurWorksheet As Worksheet

    For Each CurWorksheet In ActiveWorkbook.Worksheets

        CurWorksheet.ExportAsFixedFormat Type:=xlTypePDF, _

            Filename:=Application.ActiveWorkbook.Path & “\” & CurWorksheet.Name, _

            Quality:=xlQualityStandard, _

            IncludeDocProperties:=True, _

            IgnorePrintAreas:=False, _

            OpenAfterPublish:=False

    Next CurWorksheet

End Sub

PeterStrange 2021-4-15 09:51:24

:^(

__name__ 2021-4-15 10:25:33 非vba方法：
print哂全部sheet
再用pdf software split by every page
e.g. PDFsam （免費，幾好用）

:^(

新北市打手 2021-4-15 12:06:18

:^(

新北市打手 2021-4-15 12:11:06 用Sumprodcut做左出黎

:^(

唔該晒

PeterStrange 2021-4-15 12:11:28 sumif

狗咬狗骨頭 2021-4-15 15:02:52 有冇formula可以搵到Amax Amin Bmax......填返隔離個表？
number果行好多重複，想分返類搵返10號既A max Amin Bmax......

:^(

癸 2021-4-15 15:51:47 Max(offset (match($L2,A:A,0),Match(left(M$1,1),$C$1:$M$1,0),countif(A:A,$L2)))

可能要啲+1 -1就下啲range
再加多層if去做max / min

PeterStrange 2021-4-15 18:39:08 perfect

除左佢個match應該乜都搵唔到之外

:^(

癸 2021-4-15 18:52:46 因為column a係text?

:^(

PeterStrange 2021-4-15 22:59:54 望落應該係text黎

:^(

@o@ 2021-4-16 00:05:45 此回覆已被刪除

型英正帥 2021-4-16 16:16:08 搭單問一個類似
假設folder叫做C:\\user\
我將入面10個excel既path copy左係
Range(“D1”) 到 range(“D10”)
我想將每一個excel既sheet2 save as PDF落C:\\user\
可以點loop

:^(

癸 2021-4-16 16:38:29 FolderPath = "C:\users\"

For RowCount = 0 to 9
FilePath = Range("D1").offset(RowCount,0).value
FullPath = FolderPath & FilePath

Set TempWB as Workbooks.open(FullPath)
TempWB.Sheets("Sheet2").activate
Activesheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FullPath

TempWB.Close
Next RowCount

華素great 2021-4-19 02:54:16 我有個excel每格mark咗啲人嘅choices

（1st choice to 5th choice)
1號人蘋果雪梨香蕉提子西瓜
2號人雪梨蜜瓜菠蘿西柚藍莓
3號人雪梨提子菠蘿榴槤蘋果
......

總共有100人 total出現咗十幾種生果
而家想計蘋果&雪梨、蘋果&香蕉....
各pair喺俾人揀嘅次數

例如蘋果&雪梨 1,3號都有揀即係2次
蘋果&香蕉 1號有揀即係1次

感謝

:^(

小野菊 2021-4-19 03:01:09 此回覆已被刪除

志村新八. 2021-4-19 03:03:53

:^(

傅家俊 2021-4-19 08:59:42 呢d用VBA最好
https://www.extendoffice.com/documents/excel/785-excel-save-export-sheet-as-new-workbook.html

PeterStrange 2021-4-19 12:41:26 https://drive.google.com/file/d/1VsHMI91B9lnoxoE84-qdYKpqo0t7PuQ5/view?usp=sharing
咁??

PeterStrange 2021-4-19 12:41:52 filter

志村新八. 2021-4-19 12:45:05 Thank you so much
試試先

5天氣不似預期 2021-4-19 15:17:33 想問吓sumif 個criteria (用E3 個value 嚟比較)
係咪要好似第2條式咁先得？

=COUNTIF(B$15:B$614,"<=E3")

=COUNTIF(B$15:B$614,"<="&INDIRECT("E3"))